query to find third highest salary

Mohanbabu Sakthivelu answered on April 26, 2022 Popularity 8/10 Helpfulness 4/10

answer query to find third highest salary

Comment

-*FOR THIRD HIGHEST SALARY*

Select top 1 from (select top 3 salary from emp order by salary desc)
order by asc

Popularity 8/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: find highest sql

Link to this answer
Share Copy Link

Contributed on Apr 26 2022

Mohanbabu Sakthivelu

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.