题目：选取排序后表中的第5到第十条记录
下面是oracle中的sql实现，想必各路英雄会有更好的方法，请不啬赐教！
1、用minus也可以,至于性能请高手指点:
select * from table_name order by column_name where rownum<=10
minus
select * from table_name order by column_name where rownum<5
2、用分析函数
select * from
(select tn.*,row_number() over(order by col_name) rn from table_name tn)
where rn between 5 and 10
