一、row_number生成序列
select (row_number() over()) as id from generate_series(1,100)
二、根据指定列排序
select (row_number() over(order by test_id)) as id from test order by test_id
select (row_number() over()) as id from generate_series(1,100)
select (row_number() over(order by test_id)) as id from test order by test_id