counting distint records

clockworks · #1 (**permalink**) 06-01-04, 12:41

i have an sql statement like this:

Code:

SELECT distinct store, dept, sku
FROM some_table
WHERE some_condition

i simply want to modify it to give me the count, i tried this, but it doesn't work:

Code:

SELECT count (distinct store, dept, sku)
FROM some_table
WHERE some_condition

what am i doing wrong? thank you very much for your help.

Pat Phelan · #2 (**permalink**) 06-01-04, 13:04

This is a pure guess, but do you want something like:

Code:

SELECT Count(*), store, dept, sku
   FROM some_table
   WHERE  1 = 1 -- or some other condition of your choosing
   GROUP BY store, dept, sku

-PatP

clockworks · #3 (**permalink**) 06-01-04, 15:43

thanks for the help, yeah i think that will work, but i ended up doing something like this:

Code:

SELECT count(1)
FROM (	SELECT	distinct store, dept, sku
		FROM	some_table
		WHERE	some_condition
	)