Write a query to obtain the third-highest salary of the employee

[board-infinity]

Sql, Query

[ruble-joseph]

SELECT Salary

From Table _name

Order by Salary Desc

Limit 2,1

[chirag-garg]

As the database system isn’t mentioned the answer strictly follows T-SQL standard and only applicable to MS Sql Server.

The columns and table structure would obviously differ based on the actual scenario.