To find the 2nd largest salary from any employee table, you can use the following query:
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;