SELECT * FROM (
SELECT t.*, ROWNUM rn
FROM (SELECT * FROM user ORDER BY id) t)
WHERE rn between 1 AND 10;
SELECT * FROM (
SELECT t.*,
ROWNUM rn
FROM (SELECT
* FROM user ORDER BY id) t
WHERE ROWNUM
<= 10)
WHERE rn >= 1;
<!-- 正文结束 -->
WHERE rn between 1 AND 10;
SELECT * FROM (
WHERE rn >= 1;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23543043/viewspace-1116257/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
没有了~
下一篇：
没有了~
请登录后发表评论
登录
全部评论
