How to extract just a portion of a larger result set from a SQL SELECT.
LIMIT n is an alternative syntax to the FETCH FIRST n ROWS ONLY.
The OFFSET clause specifies the number of rows of the result table to skip before any rows are retrieved,
and must be used with the LIMIT clause.
The OFFSET clause instructs the server where to start returning rows within the query result.
For example, if a query returns 100 rows, specifying OFFSET 10 instructs the server to skip
the first 10 rows of the query results:
For example, if a query returns 100 rows, specifying OFFSET 10 instructs the server to skip
the first 10 rows of the query results:
No comments:
Post a Comment