query question

From: Shawn <spedwards_at_x.qwest.net>
Date: Mon, 12 Apr 2004 21:32:02 -0600
Message-ID: <XaJec.1138$8h2.63109@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... Received on Mon Apr 12 2004 - 22:32:02 CDT