Re: query question

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Tue, 13 Apr 2004 04:11:17 GMT
Message-ID: <FLJec.34458$M3.5467@twister.nyroc.rr.com>

"Shawn" <spedwards_at_x.qwest.net> wrote in message news:XaJec.1138$8h2.63109_at_news.uswest.net...
> 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...
>
>

This reeks of homework....
Can you tell us what you've attempted so far?

Anurag Received on Mon Apr 12 2004 - 23:11:17 CDT