SQL tuning笔试题
10-16 00:00:09
来源：http://www.qz26.com 笔试题目 阅读：8467次
导读：end loop;end;/select * from (select c.*,rownum as rn from (select * from t order by c desc) c) where rn between 21 and 30;/select * from (select * from test order by c desc) x where rownum < 30minusselect * from (select * from test order by c desc) y where rownum < 20 order by 3 desc相比之 minus性能较差上一页 [1] [2]
SQL tuning笔试题,标签：银行笔试题目,企业笔试题目,http://www.qz26.com
end loop;
end;
/
select * from (select c.*,rownum as rn from (select * from t order by c desc) c) where rn between 21 and 30;
/
select * from (select * from test order by c desc) x where rownum < 30
minus
select * from (select * from test order by c desc) y where rownum < 20 order by 3 desc
相比之 minus性能较差
Tag:笔试题目，银行笔试题目,企业笔试题目，求职笔试面试 - 笔试题目
下一条：科技技术笔试题