From: jvgreco@pop.primenet.com (TurkBear)
Subject: Re: SQL for TOP TEN
Date: 1997/12/12
Message-ID: <349150f5.163502944@news.primenet.com>#1/1
References: <66pc95$rg1@dns.okc>
Reply-To: jvgreco@jnospamprimenet.com
Organization: Primenet Services for the Internet
X-Posted-By: @151.111.254.17 (jvgreco)
Newsgroups: comp.databases.oracle.misc



While I don't know the Pl/Sql needed, Crystal Reports from Seagate
Software will do Top N reports.....

Just a thought;
John Greco
Oracle DBA ( 7.3,SqlNet 2.3, Netware 4.11 )
Reply to: john.greco@dot.state.mn.us


"Richard Long" <rlong01@dallas.net> wrote:

>I have table with 20,000 inventory items in it.  One field is a commodity
>code.  There are about 100 different commodity codes.  I need to produce a
>report that has data for the top ten(or 20) items by commodity code. There
>may be several hundred items per commodity code. Any one have a suggestion
>or a peice of canned code to do this.
>
>
>