Michael Glaesemann wrote:
> Without using UNION, (which would require writing a select statement
> for each category), how would LIMIT allow him to do this for each
> category in a single query?
You're right, it would need a UNION, and a SELECT per category.
So there'd be another SELECT to find all the categories beforehand.