Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (55.6k points)

Can anyone explain the OFFSET in SQL?

1 Answer

0 votes
by (119k points)

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:

SELECT column_name(s)

FROM table_name

The following SQL query returns the employee details except for the employee with the lowest salary:

SELECT Emp_Name

FROM Employee

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.

Related questions

0 votes
1 answer
asked Jul 19, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
0 votes
1 answer
asked Jul 26, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
asked May 4, 2023 in SQL by neelimakv (32.5k points)
0 votes
1 answer
asked Apr 2, 2021 in SQL by dev_sk2311 (45k points)

Browse Categories

...