How to list non-unique combinations of two columns with PostGreSQL?

Question

How to list non-unique combinations of two columns?

And get a result like this:

col A | col B   | count
foo   | bar     | 3
abc   | hello   | 2
def   | world   | 4

If this combination only exists once, then it's not listed:

bob   | alice     | 1

Edouard · Accepted Answer · 2021-10-25 21:57:55Z

4

SELECT col_A, col_B, count(*) AS count
FROM your_table
GROUP BY col_A, col_B
HAVING count(*) > 1

answered Oct 25, 2021 at 21:57

Edouard

7,1291 gold badge11 silver badges24 bronze badges

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

1 Answer 1