Re: Setting maximum rows to be selected

In article <12a.4156.905_at_compudata.com> barry.roomberg_at_compudata.com (Barry Roomberg) writes:
>-> display the top 20 orders based on the revenue field (which is
>-> derived from a group sum expression).
>
>Check into the "having" clause.

My knowledge is imperfect on this; however, I know of no method, with a SQL statement to acheive what you require. (HAVING ain't gonna do it.) I have read that Oracle is considering adding that functionality. Whether that was a dream or will actually come to pass, I cannot say.

I would like to add that my customers (in-house) would benefit from that functionality being added to SQL. Some are frustrated when I inform them that (what they see a simple) it is not possible to retrieve the top 5 only.

-- 
============================================================================
Michael Sallwasser  | Down one path is utter dispair and hopelessness. Down 
Northrop Grumman    | the other is total destruction. Let us choose wisely.