问个rownum应用于分页的东东?两条语句哪个效率高了??1.select*from(selectrownumids,u.*fromt_useru)t1whe
问个rownum应用于分页的东东?
两条语句哪个效率高了??
1.
select * from (
select rownum ids, u.* from t_user u) t1
where t1.ids between 10 and 20;
2.
select * from (
select t1.* from (
select rownum ids, u.* from t_user u) t1
where t1.ids <= 20) t2
where t2.ids> =10;
[解决办法]
贴出来两个sql的执行计划,看看,谁的执行计划好,就是谁的效率高了
[解决办法]
select * from (
select rownum ids, u.* from t_user u
where rownum <= 20) t2
where t2.ids> =10;
