Essential Books

Limiting amount of results

suggest change

ISO/ANSI SQL: 

SELECT * FROM TableName FETCH FIRST 20 ROWS ONLY;

MySQL; PostgreSQL; SQLite: 

SELECT * FROM TableName LIMIT 20;

Oracle: 

SELECT Id,
   Col1
FROM (SELECT Id,
           Col1,
           row_number() over (order by Id) RowNumber
      FROM TableName)
WHERE RowNumber <= 20

SQL Server: 

SELECT TOP 20 * 
FROM dbo.[Sale]
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