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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment