Re: SQL for TOP TEN

From: TurkBear <jvgreco_at_pop.primenet.com>
Date: 1997/12/12
Message-ID: <349150f5.163502944@news.primenet.com>#1/1

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_at_dot.state.mn.us

"Richard Long" <rlong01_at_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.
>
>
>
Received on Fri Dec 12 1997 - 00:00:00 CST