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查询
最新推荐文章于 2024-06-20 21:52:33 发布
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;