ORACLE分页SQL语句

ORACLE分页SQL语句

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 ...