HSQLDB Limit Query - How to Limit Rows Returned in Query Results
Sometimes it is useful to limit the number of rows that are returned from a query. This can be especially useful when querying very large tables.
The HSQLDB / HyperSQL database provides the ability to limit the number of rows returned from a query starting at the beginning of the results using the limit keyword, or returning a section of results from a query using the limit and offset syntax. Listed below are examples of limiting rows with the HSQLDB database:
Example 1: Returning the first 20 rows from a table called employee:
SELECT
*
FROM
employee
limit 20;
Example 2: Returning the first 30 rows starting at row 10 from a table called employee:
SELECT
*
FROM
employee
limit 30 offset 10;
Many other databases also support limiting rows returned from queries. Listed below are links that show how to limit rows for other popular databases:
- Cassandra Limit Rows
- DB2 Limit Rows
- Derby Limit Rows
- Firebird Limit Rows
- H2 Limit Rows
- Informix Limit Rows
- Microsoft SQL Server Limit Rows
- MySQL Limit Rows
- Oracle Limit Rows
- Pervasive Limit Rows
- PostgreSQL Limit Rows
- Redshift Limit Rows
- Salesforce Limit Rows
- SimpleDB Limit Rows
- SQLite Limit Rows
- Sybase Limit Rows
- Teradata Limit Rows
