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

16 votes221 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote201 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
11 votes207 views2 answers
MySQL DISTINCT
SQL
16 votes205 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote284 views1 answer
How to make full text search dynamic in mysql
SQL
0 vote192 views1 answer
Ffeathers express mysql application users login
SQL
1 vote230 views3 answers
Reseed sql table primary key
SQL
0 vote201 views7 answers
Les jointures sql server
SQL
9 votes212 views4 answers
Mysql show table fields
SQL
10 votes266 views2 answers
Reset mysql root password mac
SQL