The fetch first clause can sometimes be useful for retrieving only a few rows from an otherwise large result set, usually in combination with an ORDER BY clause. The use of this clause can give efficiency benefits. In addition, it can make programming the application simpler.
ROW is synonymous with ROWS and FIRST is synonymous with NEXT.
For the result offset clause, the value of the integer literal (or the
dynamic parameter
For the fetch first clause, the value of the literal (or the dynamic
parameter