分页查询 oralce sqlserver mybatic实现原理

     oracel：实现原理

SELECT *
  FROM (SELECT T.*, ROWNUM RN FROM PUB_USER T)
 WHERE RN BETWEEN 10（pageStart） AND 20(pageEnd);

sqlservel:

 select top 5 * from pub_user wehre userID not in
  (select top (n-1)*5 userID  from pub_user order by userID asc
  order by UserId asc;

mysql

 limit pageOff pageSize