Monday, 25 September 2017

how to find nth salary in mysql

select  salary from (SELECT DISTINCT salary FROM employee order by salary DESC LIMIT 1)as result order by salary ASC limit 1

No comments:

Post a Comment