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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment