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

0 vote259 views1 answer
Php xdebug docker
PHP
0 vote240 views1 answer
How can we check in the table in comma separated values in laravel
PHP Laravel
0 vote300 views1 answer
Wordpress disable edit files
PHP Wordpress
1 vote257 views1 answer
Remove http / https from link php
PHP
0 vote349 views2 answers
Codeigniter 4 db seed
PHP CodeIgniter
0 vote299 views1 answer
Mixed content laravel form target
PHP Laravel
0 vote255 views2 answers
Laravel allow all fillable
PHP
0 vote257 views1 answer
Php send json post
PHP
2 votes330 views2 answers
Tmp cakephp name
PHP CakePHP
0 vote236 views1 answer
How to select max write textarea value in php
PHP