首页 >> 文摘 >> JAVA

oracle中 rownum 对排序的影响

采集日期:2008-4-20作者:wayfoon(注:本数据由系统自动采集,内容与BHCODE无关)
select * from (select c.*, rownum rn from content c order by addtime) where rn >= 1 and rn <= 5.select * from (select rownum rn, t.* from (select title, addtime from content order by addtime desc) t) where rn >= 1 and rn <= 5.select * from (select rownum rn, t.* from (select title, addtime from content order by addtime desc) t where rownum <= 10) where rn >= 3.
本周推荐
MORE
热点关注
MORE