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 vote207 views1 answer
Generate sequence number in sql server
SQL
0 vote212 views1 answer
Sql server update top n records
SQL
11 votes205 views2 answers
Insert current date sql
SQL
0 vote216 views1 answer
How to find database collation in postgres
SQL
2 votes216 views1 answer
SQL column name Postgre
SQL
-1 vote186 views1 answer
Plsql while
SQL
8 votes214 views4 answers
How to calculate the age from date of birth in python
SQL
11 votes250 views3 answers
Change column name sql server management studio
SQL
0 vote264 views3 answers
Constraint sql
SQL
0 vote277 views1 answer
Replace null value within column mysql
SQL