Tuesday, February 17, 2009

Second Largest Number

SELECT empno FROM (SELECT e.empno, RANK() over (ORDER BY e.empno DESC) rk FROM emp e ) WHERE rk = 2
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)