Newbie SQL question (Top 10 values)

From: Rob Weeks <rweeks_at_kodak.com>
Date: 1996/01/11
Message-ID: <30F56B8F.455_at_kodak.com>#1/1

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 Received on Thu Jan 11 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Tom Cooke: "Re: Help! Power Object Unstable?"
Previous message: Lisa Roderick: "Re: TPCC - for the record it's Tandem (was Sybase 11 TPCC)"
Next in thread: Ron Levenberg: "Re: Newbie SQL question (Top 10 values)"
Reply: Marcus Williford: "Re: Newbie SQL question (Top 10 values)"
Maybe reply: Colin Lim: "Re: Newbie SQL question (Top 10 values)"
Reply: Ron Levenberg: "Re: Newbie SQL question (Top 10 values)"
Maybe reply: Reinhard Kuhn: "Re: Newbie SQL question (Top 10 values)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message