select row_.* from (select t.*,row_number() over (order by t.id) as num from t_person_info t
left join t_person_info d on t.id = d.id) row_ where num<= 500 and num> 400
SELECT * FROM (SELECT ROWNUM AS rowno, t.*
FROM t_person_info t
WHERE rownum <=500) table_alias
WHERE table_alias.rowno >= 400
left join t_person_info d on t.id = d.id) row_ where num<= 500 and num> 400
SELECT * FROM (SELECT ROWNUM AS rowno, t.*
FROM t_person_info t
WHERE rownum <=500) table_alias
WHERE table_alias.rowno >= 400
扫一扫
760
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
