MySQL LIMIT before grouping?

Question

I want LIMIT to group the results to 30, but instead I group all the rows and then limit them to 30 groups. How can I do the opposite?

SELECT *, COUNT(*) AS COUNT FROM `Posts` GROUP By `Category` LIMIT 30

+5

lisovaccaro Feb 25 '12 at 6:01

1 answer

Vadim · Accepted Answer · 2012-02-25T06:06:49+0000

SELECT *, COUNT(*) AS COUNT FROM (SELECT * FROM `Posts` LIMIT 30) t GROUP By `Category`