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

Sql, Query


From Table _name

Order by Salary Desc

Limit 2,1

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.