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

3 votes293 views2 answers
Clear cache via route laravel
PHP Laravel
1 vote271 views3 answers
Add Product Short Description To Product Category In WooCommerce
PHP
0 vote229 views1 answer
Long text in laravel migration
PHP
2 votes255 views1 answer
Permissions on ssh
PHP
15 votes314 views6 answers
Get last character of string php
PHP
2 votes230 views1 answer
Add submenu wordpress
PHP
1 vote307 views1 answer
Laravel pluralization text
PHP Laravel
-1 vote350 views1 answer
When to create a service in laravel
PHP Laravel
22 votes273 views6 answers
Php write to file
PHP
0 vote370 views1 answer
Taxonomy_get_children drupal 8
PHP Drupal