PostgreSQL数据库-分页sql--offset

select * from users order by score desc limit 3;--取成绩的前3名=====select * from users order by score desc limit 3 offset 0;--取成绩的前3名

select * from users order by score desc limit 3 offset 1;--从第二名开始往后取前三名。