Wednesday, 15 January 2014

Find Only 3rd Maximum Salary from Employee Table using Sql Server?

Ans:-

select top 1 sal from employee where sal in(select top 3 sal from employee order by sal desc) order by sal

No comments:

Post a Comment