With

DB[:items].group_and_count(:name).all

I get a list of names with the number of occurances.

What do I need to do if I only want those names returned (incluing their count) that have a count of more than e.g. 2? In SQL I would do something like this:

SELECT name, count(name) FROM items GROUP BY name HAVING count(name) > 2

CodePudding user response：

what about this?

DB[:items].group('name').having('COUNT(name) > 2')