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

0 vote110 views1 answer
Pl/ sql change currency
SQL
0 vote121 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote119 views1 answer
Find all tables where column name exists oracle
SQL
7 votes129 views1 answer
Sql limit decimal places
SQL
1 vote114 views1 answer
How to get alternate records from a table in sql
SQL
0 vote112 views2 answers
Show slave status mysql
SQL
0 vote123 views1 answer
Where field is null sql knex
SQL
1 vote115 views1 answer
Mysql view current queries
SQL
0 vote131 views1 answer
Alter table change default
SQL
0 vote120 views1 answer
Sql include rows with 0 values
SQL