查询[start,start+limit],包含start，包含start+limit,如start=21,limit=10结果就是21到30，包含21和30
SELECT * FROM (SELECT A.*, rownum rn FROM (SELECT * FROM tableName ORDER BY time DESC ) A WHERE rownum <= start + limit ) B WHERE rn >= start;
原文：http://www.cnblogs.com/blog-ice/p/7109769.html