FETCH FIRST
Description
The FETCH FIRST
clause is used to limit the number of rows returned by a query. This is similar to the LIMIT
clause in other SQL databases like MySQL. It allows to retrieve only a specific number of rows from the result set, which can be useful for pagination or for getting the top N records.
Syntax
N: The number of rows to fetch.
Example
To get the first 5 rows from the employees
table ordered by hire_date
, you can use:
Last updated