分页查询的两种方法（双top 双order 和 row_number() over ()）

--跳过2条取2条 也叫分页

select top 2 * from student
where studentno not in (
select top 2 studentno from student order by studentno
)
order by studentno

 

--row_number ()over(） 分页

select * from(
select *,ROW_NUMBER() over(order by studentno)as myid from student 
) as temp
where myid between 4 and 6