[Java] several popular database SQL Paging

[Java] several popular database SQL Paging

1. Oracle:

Select * from (select row _. *, rownum _ from (query_ SQL) Row _ Where rownum = <max) Where rownum _> = min

 

 

2. SQL Server:

Select top @ pagesize * From tablename where id not in (select top @ pagesize * (@ page-1) ID from tablename order by ID) order by ID

 

 

3. MySQL

Select * From tablename limit position, counter

 

 

4. DB2

Select * from (select *, rownumber () as row_next from tablename) Where row_next between min and Max