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

7 votes331 views1 answer
Sql server convert string to date
SQL
0 vote317 views1 answer
Sql cross apply vs join
SQL
0 vote365 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote338 views1 answer
Ubuntu connect to mssql database
SQL
0 vote344 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
8 votes336 views3 answers
Postgresql connection string c#
SQL
1 vote314 views1 answer
How to select department from table
SQL
3 votes341 views1 answer
How to find names includes in sql
SQL
0 vote383 views1 answer
Mysql delete entire row on condition
SQL
1 vote342 views1 answer
Oracle turn off constraint
SQL