Laravel groupby and latest

Group by laravel

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

Source: stackoverflow.com

Laravel groupby and latest

//If You want the latest id of records then you can use unique() after get(),
//don't use group by if you use groupBy 
//then you lose your control from id. I hope this is useful for you

myModel::select('id','purch','name','prcvalue')
  ->where('purch','=','10234')
  ->orderBy('prcvalue','DESC')
  ->get()
  ->unique('name');

Similar codes

0 vote178 views1 answer
Remove images from the the_content()
PHP
0 vote177 views1 answer
Get shipping price of choosen shipping method woocommerce
PHP
1 vote226 views4 answers
How to fix 419 page expired in laravel
PHP Laravel
0 vote174 views1 answer
Convert any date to db date in suitecrm
PHP
0 vote223 views1 answer
How to fetch all user data form user in wp
PHP
16 votes194 views6 answers
Laravel model events
PHP Laravel
44 votes196 views6 answers
How to create controller in laravel
PHP Laravel
0 vote185 views1 answer
PHP | get client ip
PHP
0 vote175 views1 answer
Php sort array by value length
PHP
6 votes190 views3 answers
How assign default value to laravel migration column
PHP