Query the first 10 pieces of data by group in laravel

When querying, You can group data by a field and then query the first few pieces of data in each group. How can you write laravel statements? When querying, You can group data by a field and then query the first few pieces of data in each group. How can you write laravel statements?

Reply content:

When querying, You can group data by a field and then query the first few pieces of data in each group. How can you write laravel statements?

Use \ App \ User; $ result = User: limit (10)-> groupBy ('name'); // you can use SQL directly if complicated statements are used (not recommended) $ result = DB: select ('select id, name from users group by name limit 10 ');