help with a query - count(distinct x)

[cfw2]

I am trying to perform a count distinct, however I would like to count a distinct grouping of columns like so:

select
count(distinct field1)
,count( distinct field1, field2)
from x

anyone have any ideas?

thank you,
cfw2

 

[vongrunt]

How about this:

select count(distinct field1), count(*)
from
(	select distinct field1, field2
	from myTable
) X

If you want to ignore rows for which field2 is NULL, replace "*" with "field2"


------
heisenbug: A bug that disappears or alters its behavior when one attempts to probe or isolate it
schroedinbug: A bug that doesn't appear until someone reads source code and realizes it never should have worked, at which point the program promptly stops working for everybody until fixed.