OFFSET clause is used along with SELECT and ORDER BY clauses to exclude the first set of rows from the result set. OFFSET is used only along with the ORDER BY clause. OFFSET value should be a positive number or zero.
Here is the syntax to use the OFFSET clause:
The following SQL query returns the employee details except for the employee with the lowest salary:
If you want to learn SQL from Industry experts then you can sign up for this SQL Training course by Intellipaat that provides Instructor-led training, hands-on experience, and certification.