SQL Server paging, MySQL paging, orcale paging

1 one, SQL Server paging:2 SELECT   TOP(Number of data bars displayed per page)* fromTable nameWHERE(ID not inch(SELECT TOP(The current page-1）*Number of data bars displayed per page-1) ID fromTable name asTable name 1_1ORDER  byID))ORDER  byID;3 two: MySQL paging4     Select  *  fromTable namewhereID limit (Current page number-1）*Number of data bars displayed per page, current page*the number of data bars displayed per page);5 Three: Orcale pagination6 SELECT  *  from(SELECTA.*, ROWNUM RN from(SELECT *  fromTable name) AWHEREROWNUM<=Current page number*Number of data bars displayed per page)WHERERn>=(The current page-1）*Number of data bars displayed per page+1);

SQL Server paging, MySQL paging, orcale paging