The fetch keyword oracle 1

The fetch keyword oracle

[ OFFSET offset ROWS]
 FETCH  NEXT [  row_count | percent PERCENT  ] ROWS  [ ONLY | WITH TIES ] 
Code language: SQL (Structured Query Language) (sql)

Here is what the above code is Doing:
1. The SELECT statement is used to select data from a database.
2. The LIMIT clause is used to set an upper limit on the number of tuples returned by SELECT statement.
3. The OFFSET clause is used to specify the offset of the first row to be returned.
4. The FETCH clause is used to specify the number of rows to be returned.
5. The ONLY clause is used to return only the result set, and not the messages.
6. The WITH TIES clause is used to include rows that match the values in the last row fetched by the query.

Similar Posts