I want to build query to return how many rows are in this query:
select distinct c1, c2 from t1

But SQL won't accept this syntax:
select count (distinct c1, c2) from t1

Does someone know how to count multiple distinct columns? Thanks.



--
Disclaimer: This post is solely an individual opinion and does not speak on
behalf of any organization.

One method is to use a derived table:

SELECT COUNT(*)
FROM (
SELECT DISTINCT c1, c2
FROM t1) AS t1

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Dean" <noreply (AT) fakeaddress (DOT) com> wrote

"Dan Guzman" <danguzman (AT) nospam-earthlink (DOT) net> wrote

Thanks! I was trying
SELECT COUNT(*) FROM (SELECT DISTINCT c1, c2 FROM t1)
but it wouldn't work without the "AS t1" at the end.

--
Disclaimer: This post is solely an individual opinion and does not speak on
behalf of any organization.

Try this out..

SELECT COUNT(*) FROM (select distinct c1, c2 from t1)T