PDA

Click to See Complete Forum and Search --> : COUNT

HJK
08-13-2001, 11:40 AM
I WANT TO COUNT DISTINCT COL1,COL2 FROM TABLE1
SELECT COUNT(*) DISTINCT COL1, COL2 FROM TALBE1
dknight
08-13-2001, 11:51 AM
Try

select count(distinct col1) from table1;

select count(distinct col2) from table1;

Good luck.
jmodic
08-13-2001, 06:16 PM
If you want to count the distinct COMBINATIONS of COL!, COL2, use the following:


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