--------------------------------SQLSERVER--------------------------
/*--------------简单的分页sql 10和0可以更改------------------*/
select top 10 * from tab where id not in(select top 0 id from tab order by id) order by id
/*--------------利用between and分页------------------*/
WITH abc AS(SELECT *,ROW_NUMBER() OVER (order by nodeid)as RowNumber FROM sysfun )
SELECT * FROM abc WHERE RowNumber between 10 and 20
----------------------------------------MYSQL------------------------------------------
select * from table limit start,pageNum
------------------------------------------ORACLE----------------------------------------------------
select * from ( select row_.*, rownum rownum_ from ( query_SQL ) row_ where rownum =< max) where rownum_ >= min