|
|
|
|
Top number of records per a category
How do I query the top 10 customers for each salesman? If I use the select
top(10), then I only get 10 results.
For a basic structure, say I had 3 tables: customer, salesman, and sales.
Customer - custid, custname, etc
Salesman - salesid, salesname, etc
Sales - id, custid, salesid, qty, desc, unitprice, totalprice, etc.
Thanks in advance,
Brian
220 500651
From: "Brian K. Sheperd"
Subject: Top number of records per a category
Date: Fri, 14 Jan 2005 14:38:13 -0500
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Message-ID:
Newsgroups
Fri, 14 Jan 2005 14:38:13 -0500
"Brian K. Sheperd"
|
|