Re: query question

Shawn wrote:

> I have a table of 20,000 rows in which I'm trying query 3 specific columns.
> Column A is a number and there are only 10 distinct numbers in column A,
> Column B is varchar which has about 25 distinct variations, and column B
> is another number but has 500 distinct numbers.
>
> I'm trying to query these 3 columns and count the number of distinct
> combinations
> of columns B and C for each of 10 distinct numbers in column A. But, I have
> just
> wall with this one.
>
> Any advice would be greatly appreciated...

Show us your work ... and we will give you a hint.

Also check out:
http://www.psoug.org/reference/group_by.html

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)