oracle分页 

   string strSql = "SELECT * FROM (SELECT t1.* ,ROWNUM  rn FROM (SELECT * FROM t_crab_base)  t1 WHERE Rownum<="+next+") WHERE rn>"+pre;

 

posted @ 2015-12-14 14:18  ChineseMoonGod  阅读(102)  评论(0)  编辑  收藏  举报