0 votes
1 view
in SQL by (35.7k points)

Can anyone explain the OFFSET in SQL?

1 Answer

0 votes
by (86.2k 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 Aug 16 in SQL by Sudhir_1997 (35.7k points)
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...