Re: Top N Results From Aggregate Values in A Select

You can also RTFM for Rank analytic function. Otherwise, select from your select statement (inline view) ordering by Request desc and selecting the N first rows using rownum. And, as Sybrand Bakker pointed it, look up the NG for Top N Queries :)

-- 
SL