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 vote242 views2 answers
Laravel 8 login logout
PHP
1 vote229 views1 answer
'https://', 'www.' & all sub derictories reomve from a url with regex
PHP
3 votes264 views2 answers
Laravel validate telephone number
PHP Laravel
0 vote230 views6 answers
Create symfony project
PHP
5 votes273 views2 answers
How to clear session in laravel
PHP Laravel
0 vote246 views1 answer
Field doesn't have default value laravel
PHP Laravel
7 votes229 views3 answers
One to many laravel
PHP
19 votes226 views5 answers
Using js variable in php
PHP
0 vote243 views2 answers
How do i use php read excel file
PHP
12 votes243 views5 answers
Php number_format
PHP