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

1 vote168 views3 answers
How to store array in variable php
PHP
3 votes220 views2 answers
Laravel tinker update password
PHP Laravel
0 vote176 views1 answer
Laravel require vendor autoload
PHP
0 vote176 views1 answer
Apagar windows desde consola
PHP
0 vote183 views1 answer
Get return value from another function laravel
PHP
1 vote198 views1 answer
Laravel websockets onsubscribe
PHP
0 vote179 views1 answer
PHP Resize
PHP
0 vote225 views1 answer
SoapClient Laravel 8
PHP Laravel
3 votes169 views1 answer
Php color echo
PHP
4 votes247 views3 answers
Wp enqueue style for style.css
PHP