Setting maximum rows to be selected

I'm running PowerBuilder Enterprise with an Oracle 7.0 back end. What I want to know is if it's possible to limit the number of rows a select statement returns. For example, a fairly complex select returns order information based on several tables, a sub-select, and use of the group by statement. Out of the 100 or so rows returned, I would like to display the top 20 orders based on the revenue field (which is derived from a group sum expression).

Neil Negandhi
negandhi_at_io.org Received on Sat Aug 13 1994 - 03:10:49 CEST