COUNT DISTINCT with a threshold

[l008com]

I've got a simple query that counts distinct items in a table

SELECT COUNT(DISTINCT flag_rest_spam.msgid) FROM flag_rest_spam

What I want to do is add a threshold to the count. What I mean is I want to count distinct items in the table, but i only want to count items that have more than N number of items. I'm not sure how to do this?

[xtopolis]

Off the top of my head, might be able to add a having clause

SELECT COUNT(DISTINCT flag_rest_spam.msgid) as frs FROM flag_rest_spam
HAVING frs > 5;

 

Not sure.

[fenway]

That's in fact the only legible way to do it.