赞
踩
row_number() over (order by A asc(desc))
下面是一个实例,从第三位开始提取 3 个记录:
runoobdb=# SELECT * FROM COMPANY LIMIT 3 OFFSET 2;