常用2种分页

2005以上

select top 10 * 
from (select row_number() 
over(order by sno asc) as rownumber,* 
from student) temp_row
where rownumber>10;

2012以上

select * from student
order by sno  
offset 10 rows
fetch next 10 rows only ;