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