select id, user_name
from (select id, user_name, rownum rowno
from (select id, user_name from users order by id)
where rownum <= 20)
where rowno >= 11;
Oracle分页(1)-伪列
最新推荐文章于 2024-09-24 11:36:02 发布
select id, user_name
from (select id, user_name, rownum rowno
from (select id, user_name from users order by id)
where rownum <= 20)
where rowno >= 11;