Re: Newbie SQL question (Top 10 values)

From: Antony Sampson <sampson_at_dtf.sa.gov.au>
Date: 1996/01/15
Message-ID: <1f7cc$d818.ad_at_murdoch.systems.sa.gov.au>#1/1

Rob Weeks <rweeks_at_kodak.com> wrote:

>How in the heck do I write a query that either returns the top 10% or
>top ten values of a specific field (sales information for instance)? In
>my MSAccess days, there was a Top 10 values wizard thingy to do the same
>type of thing. Many thanks in advance for any help that you can give me.
 

>rob weeks
>rweeks_at_kodak.com

Order the query results by the field you want the top ten values for and then include the line "AND rownum <= 10" in the query.

cheers,

---

Tony Sampson
DBA/software terrorist, South Australian Government Financing Authority sampson_at_dtf.sa.gov.au

                   The unnatural, that too is natural.
                                  Goethe

Received on Mon Jan 15 1996 - 00:00:00 CET