Filter by COUNT(*)?

Is it possible to group results and then filter by how many rows are in the group?

Something like this:

SELECT * FROM mytable WHERE COUNT(*) > 1 GROUP BY name
38
задан Mark Fox 26 October 2017 в 21:37
поделиться