/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

5 votes363 views4 answers
Update column type laravel migration
PHP Laravel
24 votes339 views6 answers
Laravel get auth user id
PHP Laravel
9 votes400 views4 answers
Convert laravel hash password online
PHP Laravel
1 vote367 views2 answers
Page expire in laravel
PHP Laravel
0 vote373 views1 answer
Double where condition in laravel
PHP Laravel
0 vote349 views1 answer
Db connection postgres laravel
PHP Laravel
7 votes319 views4 answers
Laravel chunk
PHP Laravel
0 vote340 views6 answers
Laravel get last id
PHP Laravel
23 votes322 views6 answers
Laravel 8 route
PHP Laravel
0 vote410 views1 answer
Failed to open stream permission denied laravel
PHP Laravel