SubsDotNet
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
‹
›
Home
View web version
No comments:
Post a Comment