Thursday, May 12, 2016

SQL : second highest salary

select * from
( select salary,dense_rank() over(order by grade salary) as r
from customer
) as E
where r = 2

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)