SELECT tableTwo.* FROM (SELECT ROWNUM as id,tableOne.* FROM 表名字 tableOne WHERE ROWNUM <n) tableTwo WHERE id >m
oracle数据库,根据rownum查询第m行到第n行数据
最新推荐文章于 2024-06-13 21:08:41 发布
SELECT tableTwo.* FROM (SELECT ROWNUM as id,tableOne.* FROM 表名字 tableOne WHERE ROWNUM <n) tableTwo WHERE id >m