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 votes307 views1 answer
Laravel route required parameters
PHP
1 vote308 views2 answers
Get all values inside session laravel
PHP
0 vote296 views1 answer
How to Manually Upgrade phpMyAdmin on Ubuntu
PHP
0 vote398 views2 answers
Laravel check if string is url
PHP Laravel
26 votes305 views2 answers
Php artisan clear commands
PHP
1 vote286 views3 answers
Woocommerce get post meta
PHP
0 vote516 views1 answer
Load-styles.php 403
PHP
0 vote301 views2 answers
Php function to remove underscore
PHP
0 vote322 views1 answer
Php json array push in js file
PHP
5 votes306 views2 answers
Laravel - Send mail using mail class
PHP