面试之BI-SQL--table转换
Num
1
2
4
6
7
8
10
11
13
写条SQL语句转成下表：
Column1 Column2
1 2
4 4
6 8
10 11
13 13
selectMIN(Num),MAX(Num)from (selectROW_NUMBER()over (orderbyNum)rk,Num FromNumbers)A Groupby (A.rk-A.Num) orderbyMin(Num)