1.Oracle:select * from ( select row_.*, rownum rownum_ from ( query_SQL ) row_ where rownum =< max) where rownum_ >= min2.SQL Server:select top @pagesize... [orderby]