摘要:
1.根据ROWID来分select * from t_xiaoxi where rowid in(select rid from (select rownum rn,rid from(select rowid rid,cid from t_xiaoxi order by cid desc) where rownum10000) where rn9980) order by cid desc;执行时间0.03秒2.按分析函数来分select * from (select t.*,row_number() over(order by cid desc) rk from t_xiaoxi t) 阅读全文