Re: General approach to "Top-x-items" selection?
Date: 1995/08/11
Message-ID: <40fp1t$sqq_at_stc06.ctd.ornl.gov>#1/1
From: Martin Smith <MikeS_at_cpcug.org>
Newsgroups: comp.databases.oracle
Subject: General approach to "Top-x-items" selection?
Date: 11 Aug 1995 01:38:34 GMT
Organization: Express Access Online Communications, USA
Message-ID: <40ecar$evo_at_news1.digex.net>
We have a common requirement to produce reports on the top x items by some value within categories (and sometimes subcategories).
Example--What are the top 10 items (in 1994 value) imported from each country in the world?
I can't believe this is not a common need (not the problem, but simliar ones like the top 10 salesmen in each region or the top 10 salaries in each department.)
Is there a general way to accomplish this using Oracle?
Thanks! Received on Fri Aug 11 1995 - 00:00:00 CEST