不需要排序
select (row_number() over()) as id from generate_series(1,100)
根据指定的字段排序
select (row_number() over(order by xxx desc)) as id,xxx from generate_series(1,100) as xxx
不需要排序
select (row_number() over()) as id from generate_series(1,100)
根据指定的字段排序
select (row_number() over(order by xxx desc)) as id,xxx from generate_series(1,100) as xxx