Min varias colunas spark sql

> SELECT a, b, lead(b) OVER (PARTITION BY a ORDER BY b) FROM VALUES ('A1', 2), ('A1', 1), ('A2', 3), ('A1', 1) tab(a, b);
 A1 1   1
 A1 1   2
 A1 2   NULL
 A2 3   NULL

Source: spark.apache.org

Similar codes

0 vote116 views1 answer
Change role postgres
SQL
1 vote128 views1 answer
Mysql query bulk insert
SQL
0 vote117 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote118 views1 answer
Oracle procedure chain step
SQL
0 vote113 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote131 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote88 views1 answer
Sql runnignsum
SQL
0 vote112 views1 answer
Tsql delete all rows
SQL
2 votes143 views2 answers
Install postgresql
SQL
6 votes122 views2 answers
Can't connect to local mysql server through socket
SQL