pgsql查询结果生成序列

一、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
posted @ 2021-09-16 16:46  hziwei  阅读(1288)  评论(0)  编辑  收藏  举报