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

0 vote286 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
0 vote264 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote236 views1 answer
Oracle sysdba connect as another user
SQL
0 vote292 views1 answer
Oracle sql alter view add column
SQL
0 vote310 views1 answer
How to make sure two tables have same exact data in sql
SQL
8 votes298 views1 answer
My sql version
SQL
0 vote283 views1 answer
Show table details postgresql
SQL
0 vote265 views2 answers
How to find max and min salary in sql
SQL
3 votes276 views3 answers
How to add month in update sql
SQL
1 vote300 views2 answers
One to one and one to many relationship
SQL