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

4 votes139 views1 answer
Ubuntu set alternatives
PHP
3 votes140 views1 answer
Array_unique
PHP
0 vote156 views2 answers
How to implement maatwebsite excel in my laravel project
PHP
0 vote209 views1 answer
Supprimer automatiquement les mots courts des URL pour un meilleur SEO dans WordPress
PHP Wordpress
0 vote171 views1 answer
Blade Keep input values after failed validation
PHP
0 vote159 views1 answer
Wordpresss loop through object
PHP
3 votes122 views2 answers
Cannot create an instance of class viewmodel
PHP
0 vote140 views1 answer
33
PHP
1 vote139 views1 answer
Validate executable path vscode
PHP
0 vote120 views1 answer
Long text in laravel migration
PHP