I WANT TO COUNT DISTINCT COL1,COL2 FROM TABLE1
SELECT COUNT(*) DISTINCT COL1, COL2 FROM TALBE1
Printable View
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);