string strSql = "SELECT * FROM (SELECT t1.* ,ROWNUM rn FROM (SELECT * FROM t_crab_base) t1 WHERE Rownum<="+next+") WHERE rn>"+pre;
oracle分页
原文:http://www.cnblogs.com/ChineseMoonGod/p/5045135.html