【SQLSERVER】offset fetch next 取第几行

offset fetch next 用法

--跳过第一个取2行
select * from student 
order by id 
offset 1 row  --跳过行数，从0开始
fetch next 2 row only --取几行

Top用法

select top 1 * from student

row_number()用法

SELECT * FROM  
(SELECT * , ROW_NUMBER() OVER(ORDER BY id)  as rn  FROM student) t 
 WHERE rn>1 AND rn<=3

offset fetch next 和row_number()方式可以用于分页