COUNT

I WANT TO COUNT DISTINCT COL1,COL2 FROM TABLE1
SELECT COUNT(*) DISTINCT COL1, COL2 FROM TALBE1

Try

select count(distinct col1) from table1;

select count(distinct col2) from table1;

Good luck.

If you want to count the distinct COMBINATIONS of COL!, COL2, use the following:


SELECT COUNT(*) FROM
(SELECT DISTINCT COL1, COL2 FROM TALBE1);