sqlserver语句:
select top pageSize * from t where t.id not in (select top (pageNow-1)*pageSize id from t);
MySQL语句:
select t.* from t limit (pageNow-1)*pageSize,pageSize;
Oracle语句:
select * from (select rownum r,a.* from (select * from t) a where rownum<= pageNow*pageSize) tmp
where r> (pageNow-1)*pageSize;