How to get the Nth highest salary of an employee?

1. Full .NET Interview Course (with PDF Book)

C# / ASP.NET Core / MVC / API - Top 500 Interview Questions

Don't worry if course not helping you, Udemy has 30 days Free Refund Policy.

2. Quick Revision Book (PDF format)

Top 500 .NET Interview Questions - OOPS/ C#/ ASP.Net/ MVC/ SQL /.Net Core /Web API

50% Discount Applied on above link.

My best wishes are with you.

[rifatislamrakesh]

thank you, sir, keep posting these kinds of shorts!

[electricalsir]

With temp as
(Select salary
Dense_rank() over (partition by salary order by sal desc) as rn from employee);
Select salary from temp where rn = 3;

[electricalsir]

Select salary from employee group by id order by salary desc limit 2, 1;

[ermahesh]

sir better to use window function like rownumber

[ArjunSingh-cyeq]

Good afternoon sir I'm executing this query in SQL oracle 10 g it not working

[pareshpatil]

any another short query to get same answer...it is so complicated