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()方式可以用于分页