/PHP/Laravel/Laravel group by with where clause

Laravel group by with where clause

Group by laravel

$user_info = DB::table('usermetas')
                 ->select('browser', DB::raw('count(*) as total'))
                 ->groupBy('browser')
                 ->get();

Source: stackoverflow.com

Laravel group by with where clause

$groupedSalesCampaign = Order::with('Campaign')
            ->where('isapproved','=','Y')
            ->groupBy('campaign_id')
            ->orderBy(DB::raw('COUNT(id)','desc'))
            ->get(array(DB::raw('COUNT(id) as totalsales'),'campaign_id'));

Source: stackoverflow.com

Similar codes

1 vote229 views1 answer
Laravel 8 validation required if another field is not null
PHP Laravel
1 vote253 views1 answer
Laravel api form request validation 404
PHP Laravel
0 vote225 views1 answer
Laravel list all tbales
PHP Laravel
10 votes214 views4 answers
Print last query laravel
PHP Laravel
0 vote207 views1 answer
Laravel CORS config `allowed_origins` should be an array
PHP Laravel
3 votes233 views2 answers
Laravel longblob migration
PHP Laravel
10 votes227 views3 answers
Get current date carbon laravel
PHP Laravel
12 votes206 views4 answers
Laravel return redirect to named route
PHP Laravel
0 vote200 views1 answer
String length laravel validation
PHP Laravel
0 vote168 views1 answer
How to get event dates on change in datetimepicker with laravel livewire
PHP Laravel