各数据库分页语法

• MYSQL

SELECT ID FROM MY_TABLE LIMIT 5, 10

• MARIADB

 SELECT ID FROM MY_TABLE LIMIT 5, 10

• H2

SELECT ID FROM MY_TABLE LIMIT 5, 10

• CLICK_HOUSE

SELECT ID FROM MY_TABLE LIMIT 5, 10

• DERBY

SELECT ID FROM MY_TABLE OFFSET 5 ROWS FETCH NEXT 10 ROWS ONLY

• HSQL

SELECT ID FROM MY_TABLE OFFSET 5 ROWS LIMIT 10

• INFORMIX

SELECT SKIP 5 FIRST 10 ID FROM MY_TABLE

• ORACLE

SELECT * FROM (SELECT TMP_PAGE.*, ROWNUM RN 
FROM (SELECT ID FROM MY_TABLE) TMP_PAGE) WHERE RN > 5 AND RN <= 15

• DB2

SELECT * FROM (SELECT TMP_PAGE.*, ROW_NUMBER() OVER() AS RN 
FROM (SELECT ID FROM MY_TABLE) AS TMP_PAGE) WHERE RN > 5 AND RN <= 15

• SQL_SERVER2005

SELECT * FROM (SELECT TMP_PAGE.*, ROW_NUMBER() OVER() AS RN 
FROM (SELECT ID FROM MY_TABLE) AS TMP_PAGE) WHERE RN > 5 AND RN <= 15

• ORACLE12

SELECT ID FROM MY_TABLE OFFSET 5 ROWS FETCH NEXT 10 ROWS ONLY

• POSTGRE_SQL

SELECT ID FROM MY_TABLE LIMIT 10 OFFSET 5

• SQLITE

SELECT ID FROM MY_TABLE LIMIT 10 OFFSET 5

• SQL_SERVER2012

SELECT ID FROM MY_TABLE OFFSET 5 ROWS FETCH NEXT 10 ROWS ONLY

• FIREBIRD

SELECT ID FROM MY_TABLE ROWS 5 TO 15