Min varias colunas 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

1 vote336 views2 answers
Logical operators in sql
SQL
0 vote343 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
1 vote313 views1 answer
Search for tables with name postgresql
SQL
0 vote317 views3 answers
Get free card roblox
SQL
2 votes338 views4 answers
Mysql get all tables row count
SQL
0 vote331 views1 answer
Mysql query to check record exists in database table or not
SQL
7 votes301 views4 answers
How to reset the identity column in sql server
SQL
0 vote304 views1 answer
Oracle list chain steps
SQL
0 vote333 views1 answer
Suse status MySQL
SQL
1 vote320 views2 answers
Check if word is in column sql
SQL