Monday, December 22, 2008

top-n Analysis in oracle

select * from (select * from top_dogs order by salary DESC)where ROWNUM<=3
top 3 salary earners

No comments:

Post a Comment