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 votes99 views2 answers
Get all tables using like
SQL
0 vote98 views1 answer
Sql server inner join convert collation
SQL
35 votes106 views6 answers
Postgres
SQL
0 vote98 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
5 votes113 views1 answer
Mysql count newlines in field
SQL
2 votes99 views1 answer
Sql like variable
SQL
1 vote121 views2 answers
Mysql insert generate serie
SQL
0 vote98 views1 answer
Oracle index hint
SQL
0 vote96 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
-1 vote126 views1 answer
Search all sql tables for a value
SQL