Technical Solutions
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
‹
›
Home
View web version
No comments:
Post a Comment