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

2 votes328 views1 answer
Get first 2 letter in sql
SQL
10 votes330 views2 answers
Show tables in schema oracle
SQL
0 vote332 views1 answer
ORACLE PARSE STRING
SQL
10 votes357 views4 answers
SELECT FROM WHERE
SQL
3 votes312 views1 answer
Sql multiple column index
SQL
13 votes320 views2 answers
Check if value is null mysql
SQL
0 vote340 views1 answer
Automated psql csv export script on windows
SQL
0 vote348 views1 answer
Show the colums of table sql
SQL
0 vote329 views1 answer
Regex mongoose
SQL
1 vote354 views1 answer
Mysql search like order by best match
SQL