To find out Third Highest Salary

Posted by Amatya under Sql Server category on 12/12/2016 | Points: 40 | Views : 965

Post Code |

Search Codes |

Code Home

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

Alert Moderator

Bookmark It

Comments or Responses

Latest Code Snipptes

writing Custom pagination html code in python and django
Code snippet for setInterval
Azure Function - Connect to MS Dynamics using application user - .NET core 3.1
MS Dynamics 365- Custom action - Read input parameter values from plugin
MS Dynamics 365- Disassociate record from N-N relationship entity
Search box with icon in Navbar in bootstrap 4
Remove HTML tags using Regular Expression in C#
MS Dynamics 365- Close Quote from C# / Custom action
How to show and hide submenu in tabs using jquery
More ...