sqlserver和oracle以及mysql的分页

1.sqlserver分页语法：

   select * from (select ROW_NUMBER() over(order by empid) rownum from employee)t where rownum>4 and rownum<=6

2.oracle分页语法：

  select * from (select t.*,rownum rn from (select * from employee order by empid)t where rownum <=6) where rn>4

3.mysql分页语法：

   select * from employee where empid limit 0,20;