Write an SQL query to get third maximum salary of an employee from a table named employee_table.Ask Questions

 Posted on 08/03/2018

                                                                                             
Share On: facebook gplus twitter
profile
Asked by Hardik Parekh on 08/03/2018 Score: 234 points
Add Comment:

Comments

1 Answers

1 Corrected Answers
Aproved Answers
2
Profile
Answered by Shailesh Chaudhary on 8/3/2018 8:46:56 AM Score: 800 points

There are so many ways to get nth highest salary from employee.

1)  USING TOP 

SELECT MIN(SALARY) FROM ( SELECT DISTINCT TOP 3 SALARY FROM dbo.EMPLOYEE ORDER BY SALARY DESC ) AS A

2) Use ROW_NUMBER(if you want a single) or DENSE_RANK(for all related rows):

WITH CTE AS
(
    SELECT SALARY,
           RN = ROW_NUMBER() OVER (ORDER BY SALARY DESC)
    FROM dbo.EMPLOYEE
)
SELECT SALARY
FROM CTE
WHERE RN = @NthRow

 

Comments

Add Comment:

Post Your Answers

Existing Members

Sign in to your account
Email Address
Password
New Member?
Sign up and complete profile
Full Name
Email Address
I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the StoodQ newsletters
Guideline to answer a question:

Useful tips to submit your answer
Please read below guidelines before you submit your answer for question.

  • Read and understand question for which you are submitting your answer.
  • Try to avoid grammatical and spell mistake while answering.
  • Do not post any irrelevant information in your answer.
  • Explain your answer with example or any reference link to help who posted question.
  • If you find irrelevant question, please report it to support. Click here to contact support.
  • You agree to the privacy policy and terms of use to submit any contents.

Note: StoodQ is online developers community which helps developer for their difficulty, lets help them with your value contribution.