Re: Newbie SQL question (Top 10 values)
From: Ron Levenberg <ral_at_cc.bellcore.com>
Date: 1996/01/24
Message-ID: <4e5ft3$ib2_at_athos.cc.bellcore.com>#1/1
Date: 1996/01/24
Message-ID: <4e5ft3$ib2_at_athos.cc.bellcore.com>#1/1
According to Ralph Kimball's column on page 14 of the 2/96 issue of DBMS magazine, SQL has no such ranking function. He talks about the impossibility of doing this.
Ron Levenberg - ral_at_cc.bellcore.com
--- Rob Weeks <rweeks_at_kodak.com> wrote:Received on Wed Jan 24 1996 - 00:00:00 CET
>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