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 vote286 views1 answer
Clear array php
PHP
31 votes286 views5 answers
Php remove last newline from string
PHP
4 votes290 views2 answers
Get session blade
PHP
0 vote294 views1 answer
Php foreach random
PHP
0 vote330 views1 answer
Laravel jwt check token sent by request is valid
PHP Laravel
0 vote273 views3 answers
Br2nl
PHP
1 vote387 views1 answer
How to calculate age in laravel
PHP Laravel
3 votes264 views1 answer
Check if post request php
PHP
17 votes296 views5 answers
Wordpress debug mode
PHP
1 vote306 views1 answer
[InvalidArgumentException] Could not find package laravel/laravel with version 7.0 in a version installable using your PHP version, PHP extensions and Composer version.
PHP