`

sqlserver分页查询

 
阅读更多
//从0开始每次查10条记录

select top 10 * from student where 1=1 and id not in ( 
select top 0 id from student where 1=1 order by id ) order by id
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics