Third highest Salary:-

Query

SELECT TOP 1 salary FROM (SELECT TOP 3 salary FROM [dbo].[tbl_EmpDetails] ORDER BY salary DESC)

AS emp ORDER BY salary ASC

results matching ""

    No results matching ""