Pervasive 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 Pervasive database provides the ability to limit the number of rows returned from a query starting at the beginning of the results using the top keyword. Listed below are examples of limiting rows with the Pervasive database:

Example 1: Returning the first 10 rows from a table called employee: SELECT TOP 10 * FROM EMPLOYEE; Example 2: Returning the first 50 rows from a table called sales: SELECT TOP 50 * FROM SALES;

Many other databases also support limiting rows returned from queries. Listed below are links that show how to limit rows for other popular databases: