I would have the same approach.
To select the count from something grouped, you can use a Raw exression. The group by clause is simple.
$ethnicityAndCountArray = Employee::select(DB::Raw('Ethnicity, COUNT(*) as count'))
->groupBy('Ethnicity');
The result will be an array with objects containing Ethnicity and count each.
$total = 0;
foreach($ethnicityAndCountArray as $ethnicity)
$total += $ethnicity->count;
Last updated
2 years ago.
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast