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

3 votes296 views1 answer
Apex call duration
SQL
0 vote219 views1 answer
Sql show all users
SQL
0 vote231 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote243 views1 answer
Sql basic commands
SQL
3 votes210 views2 answers
Plsql print
SQL
0 vote212 views1 answer
Inner joint
SQL
0 vote217 views1 answer
Pl sql round
SQL
16 votes232 views1 answer
Mysql reset auto increment value
SQL
1 vote183 views1 answer
Database run
SQL
0 vote209 views1 answer
Sql server whoami
SQL