Select Distinct multiple columns, count distinct

Question

How do you select distinct, and count of distinct? I have a table:

col1    col2
 1       1
 1       0
 0       0
 0       1
 1       1
 0       0

And I'm trying to get this:

col1    col2    count
 1       1        2
 1       0        1
 0       0        2
 0       1        1

Himanshu · Accepted Answer · 2017-12-28 04:30:25Z

1

You just need to use GROUP BY clause with multiple columns.

SELECT col1, col2, COUNT(*) FROM Table1
GROUP BY col1, col2

answered Dec 28, 2017 at 4:30

Himanshu

32.8k32 gold badges117 silver badges137 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1