SQL分页语句

觉得一个比较通用的SQL分页语句

select * from
    (select ROW_NUMBER() over (order by stuid desc)as num,*
        from Student
            where stuIsDel=0)as tbl
        where tbl.num between 1 and 10

//其中between 1 and 10 可以更换成变量形式为

1,between (@page-1)*@count+1 and @page*@count ;

2,* 在查询字段时最好都写成要查询的字段;

转载于:https://my.oschina.net/u/813002/blog/99554