Firebird Select Top Syntax

The "select top" syntax is a syntax used by certain databases to limit the returned rows to the first N rows of a query.

Firebird does have a way to select the top N rows from an SQL query, but the syntax does not use the top keyword. Instead, the "first" keyword must be used.

For example, databases that support the top syntax may use the following syntax to return the first 1000 rows from a query:

select top 1000 * from sales

The Firebird equivalent of the above syntax would be the following:

select first 1000 * from sales

For more examples of how to limit rows with Firebird, please visit the following: Firebird Limit Rows