How would I find the second largest salary from a employee table closed

Question

How would I go about querying for the second largest salary from all employees in my Employee table?

Answer 1

To find the 2nd largest salary from any employee table, you can use the following query:

SELECT distinct(sal)
FROM emp
ORDER BY sal DESC
LIMIT 1, 1;

*Here, emp is the employee table
           sal is the salary table

 WIth this query you can only get the second max salary.

And if you need any 3rd or 4th or Nth value, you can replace the first value followed by the LIMIT (n-1) 
ie. for 5th salary : LIMIT 4, 1;