SELECT TMP_PAGE.*, ROWNUM ROW_ID FROM ( SELECT * FROM 表名 WHERE 1 = 1 ) TMP_PAGE WHERE ROWNUM <= 10
分页查询语句
最新推荐文章于 2024-09-09 23:37:05 发布
SELECT TMP_PAGE.*, ROWNUM ROW_ID FROM ( SELECT * FROM 表名 WHERE 1 = 1 ) TMP_PAGE WHERE ROWNUM <= 10