I have a select query which groups by a specific field. I need to limit the result to N group not N record.
For example in first page, user may see 5 groups which contains 30 records totally but in second page user may see again 5 groups but they contain 50 records totally.
What is important for me, is to display 5 groups per page not a specific individual records.