Sunday 18 August 2013

How to Find 6th Highest Salary from a Table

Select min(salary) from (select salary from emp_table order by salary desc limit 6) from emp_table order by salary
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)