How to find 3rd highest salary in MySQL

Question

Very common interview question

Answer 1

SELECT DISTINCT salary FROM `table_name` order by salary DESC LIMIT 1 OFFSET 2

Answer 2

thank you idrees