代码改变世界

SQL server分页

2020-07-07 08:24  idea555  阅读(136)  评论(0)    收藏  举报

set statistics time on
select top 3 * from (select row_number() over(order by s_id asc) as rowNumber,* from student) temp_table where rowNumber>((2 - 1)*3)