Friday, 12 April 2013

Display the Top two maximum salaries of table

          select salary from (select salary, dense_rank() over(order by salary) rnk from emp )as e where rnk<=2
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)