Re: General approach to "Top-x-items" selection?

ekramer_at_coil.com (Eric Kramer) wrote:

>1) Write the full query, including an ORDER BY clause ordering the
>result set by the desired attributes
>2) Add to the WHERE clause a statement to limit results to
>ROWNUM <= 10

Important disclaimer... if there are several rows that tie for 10th place, this query will not include them (just as you'd expect). You just need to keep that in mind when interpreting the results (or automatically using them in some batch process).

        Eric

Eric S. Kramer
Huntington Bancshares Incorporated
Columbus, OH USA
(614) 480-5088 Received on Mon Aug 14 1995 - 00:00:00 CEST