PostgresQL 中有没有rownum这样的,显示结果集的序号
select * from (select row_number() over() as rownum,tablename from pg_tables) t where rownum<10;
posted on 2018-08-29 10:25 nickTimer 阅读(2592) 评论(0) 编辑 收藏 举报
select * from (select row_number() over() as rownum,tablename from pg_tables) t where rownum<10;
posted on 2018-08-29 10:25 nickTimer 阅读(2592) 评论(0) 编辑 收藏 举报