sql生成行号
sqlsql:
不分组行号:
select ROW_NUMBER() over ( order by 订单编号) from test
分组行号:
select ROW_NUMBER() over (partition by 订单编号 order by 订单编号) from test
mysql:
不分组行号:
SELECT
@r:=@r+1 AS rouNum,
a.* FROM s_t1 a,(SELECT @r:=0) b
oracle:
不分组行号:
SELECT *, Row_Number() OVER (ORDER BY salary desc) rank FROM employee
分组行号:
SELECT *, Row_Number() OVER (partition by deptid ORDER BY salary desc) rank FROM employee