If your table name is emp and the name, sal are two columns of table. then you can easily find out nth highest salary from the table with the help of this query
SELECT DISTINCT sal FROM emp ORDER BY sal DESC LIMIT (n-1),1 ;
If you want to find 3rd highest sal your query will be
SELECT DISTINCT sal FROM emp ORDER BY sal DESC LIMIT 2,1 ;
How to display nth highest record in a table for example ?
Related Answered Questions
Related Open Questions