Error while using FETCH/OFFSET fucntion in SQL

Question

I am currently learning SQL, I was trying to get the 2nd highest salary using the following code:

SELECT Name, Address, Salary
FROM Employees 
ORDER BY Salary DESC
OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;

This is the error that I am receiving: Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY' at line 4

I have read article online, but I still can't find what the error is.

This is sql-server code that youare attempting to use in MYSQL the 2 dialects are different. If you want to learn sql server there is a free version available — P.Salmon
– P.Salmon, Commented May 18, 2022 at 7:32

Omer · Accepted Answer · 2022-05-18 05:02:04Z

1

You have to use LIMIT instead of FETCH NEXT rows as it is not MySQL syntax. Also go through the following link where it is mentioned briefly SQL code error (OFFSET 0 ROWS FETCH FIRST 10 ROWS ONLY)

USE THE FOLLOWING QUERY INSTEAD OF ABOVE ONE TO GET SECOND HIGHEST VALUE

SELECT Name,Address,Salary from Employees GROUP BY Salary ORDER BY Salary DESC LIMIT 1,1

edited May 18, 2022 at 5:02

answered May 18, 2022 at 4:56

Omer

344 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mayank Sinha Over a year ago

Thanks. I read some articles regarding this and all of them did the exact thing. I was so confused on what I am doing wrong.

Collectives™ on Stack Overflow

Error while using FETCH/OFFSET fucntion in SQL

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related