SQL for TOP TEN

From: Richard Long <rlong01_at_dallas.net>
Date: 1997/12/11
Message-ID: <66pc95$rg1@dns.okc>#1/1

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 Thu Dec 11 1997 - 00:00:00 CST