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

22 votes100 views2 answers
Php if elseif endif
PHP
10 votes99 views3 answers
Get day by date in php
PHP
0 vote100 views1 answer
E: Couldn't find any package by regex 'php7.2-json'
PHP
0 vote120 views1 answer
Wordpress get archive title
PHP Wordpress
0 vote105 views1 answer
Laravel npm build production
PHP
3 votes94 views1 answer
Laravel check if environment is production
PHP
0 vote96 views1 answer
Php isset post
PHP
0 vote150 views1 answer
Symfony user online
PHP Symfony
2 votes123 views1 answer
Go back URL in Laravel
PHP Laravel
3 votes117 views2 answers
Laravel 7 view @php
PHP Laravel