Least 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

10 votes325 views2 answers
Show tables in schema oracle
SQL
0 vote311 views1 answer
Oracle index hint
SQL
0 vote348 views1 answer
Sql pivot table
SQL
3 votes339 views4 answers
Psql list tables in schema
SQL
0 vote339 views1 answer
T sql dynamic top n query
SQL
9 votes311 views3 answers
Sequence postgresql
SQL
0 vote315 views1 answer
How to get table current identity value in sql server
SQL
4 votes326 views2 answers
Postgresql default value
SQL
0 vote308 views1 answer
Sum sqlserver
SQL
0 vote328 views2 answers
What is the default password for sql server sa
SQL