sqlserver分页

1、sqlserver分页语句：

按照id逆序排列,查询第二页数据:

第一种写法:

select top 10 * 

from StudentDetaileTAB 
where  id not in
(select top 10 id from StudentDetaileTAB 
order by id desc
)
order by id desc
;

第2种写法(此写法在数据量大时效率较高):
select * 
FROM StudentDetaileTAB w1 
where id in (  
SELECT top 10 ID FROM  
( 
SELECT top 20 ID FROM StudentDetaileTAB 
ORDER BY id desc
) w ORDER BY  w.ID asc
) ORDER BY w1.ID desc
;

2、mysql分页语句：

select * from table1 limit (pagenum-1)*pagesize,pagesize。

例子：select * from StudentDetaileTAB limit 10,5