查询数据显示第2页(其中每页有4条数据),Student为一个表,学号是该表其中的列名
第一:
select top 4 * from Student where 学号 not in
(select top (1*4) 学号 from Student order by 学号) order by 学号
第二:
with coun as(select row_number() over(order by 学号)as row_number,* from Student)
select * from coun where row_number between (1*4) and (1*4+4) order by 学号
第三:
select top 4 * from(select top (2*4)* from Student order by 学号 desc)a order by 学号 desc