Essential Books

Skipping then taking some results Pagination

suggest change

ISO/ANSI SQL: 

SELECT Id, Col1
FROM TableName
ORDER BY Id
OFFSET 20 ROWS FETCH NEXT 20 ROWS ONLY;

MySQL: 

SELECT * FROM TableName LIMIT 20, 20; -- offset, limit

Oracle; SQL Server: 

SELECT Id,
   Col1
 FROM (SELECT Id,
           Col1,
           row_number() over (order by Id) RowNumber
      FROM TableName)
WHERE RowNumber BETWEEN 21 AND 40

PostgreSQL; SQLite: 

SELECT * FROM TableName LIMIT 20 OFFSET 20;
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

SKIP TAKE pagination:
*SKIP TAKE Pagination
*Limiting amount of results
*Skipping then taking some results Pagination
*Skipping some rows from result
Table Of Contents