FETCH FIRST n ROW ONLY and OPTIMIZE FOR n ROWS

The FETCH FIRST n ROW ONLY clause is used to limit the result set of a query to a specified number of rows. It is particularly useful when you are only interested in retrieving a subset of the total records. Retrieving the entire result table from the query can be inefficient. You can specify this […]

FETCH FIRST n ROW ONLY and OPTIMIZE FOR n ROWS Read More »