摘要:
select array_to_json(array_agg(row_to_json(t))) from (SELECT * FROM test) t 阅读全文
摘要:
一、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 阅读全文