OFFSET
is a clause that skips some records from the result set.
OFFSET
clause is shown below:
columns
: the columns to be fetched.table_name
: a table from which the records will be fetched.OFFSET
: a clause that will skip a subset of records.
num
: the number of records to be skipped.CREATE TABLE
command and inserting some values into the table using the INSERT
command: