To find out Third Highest Salary

Amatya
Posted by Amatya under Sql Server category on | Points: 40 | Views : 167
This is Important question in Interview for fresher to 2 year Experience guys in C# and SQL server. Hope it helps

Select Max(Salary) from [Amatya].[dbo].[EmpSal] where Salary < 
(Select Max(Salary) from [Amatya].[dbo].[EmpSal] where Salary <
(Select Max(Salary) from [Amatya].[dbo].[EmpSal]))


Thanks
Amatya

Comments or Responses

Login to post response