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.
