Tuesday, October 21, 2008

Top N Salaries

SQL> Select
rownum as Rank,ename,sal
from (select ename,sal from emp order by sal desc)
where rownum <=3
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)