postgresql查询某记录前N行:
SELECT * FROM table LIMIT N;
postgresql查询某记录最后后N行:
SELECT * FROM table order by id desc LIMIT N;
postgresql查询某记录从M行开始N行:
SELECT * FROM table LIMIT N OFFSET M;
postgresql查询
最新推荐文章于 2022-01-21 17:45:41 发布
postgresql查询某记录前N行:
SELECT * FROM table LIMIT N;
postgresql查询某记录最后后N行:
SELECT * FROM table order by id desc LIMIT N;
postgresql查询某记录从M行开始N行:
SELECT * FROM table LIMIT N OFFSET M;