分页查询语句

1.SQLServer

最小值 = (当前页码 - 1) * 每页条数 + 1

最大值 = 当前页码 * 每页条数

select 字段名称... from (select num=ROW_NUMBER() OVER(排序字符串),字段名称... from 表名 查询条件) as 别名

where 别名.num>=最小值 and 别名.num<=最大值

例：

select staff_id,staff_name from (select num=ROW_NUMBER() OVER(order by graduated_time),staff_id,staff_name from dt_staff where staff_id>300) as staff where staff.num>=11 and staff.num<=20

2.mySql

select 字段名称... from 表名 查询条件 排序字符串 limit (当前页码 - 1) * 每页条数,每页条数;

例：

select sid,sname from dt_student where sname like '%ovo%' order by sid desc limit 0,10;