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

11 votes224 views6 answers
Laravel route
PHP Laravel
0 vote207 views1 answer
Laravel imap - Set message flags
PHP Laravel
15 votes179 views6 answers
Laravel migration delete column
PHP Laravel
12 votes220 views2 answers
Laravel query with trashed
PHP Laravel
12 votes186 views5 answers
Laravel run single migration
PHP Laravel
0 vote191 views1 answer
Die laravel
PHP Laravel
1 vote190 views1 answer
How to set a validation on a value if its not null in laravel php
PHP Laravel
10 votes176 views6 answers
Laravel Pagination
PHP Laravel
1 vote231 views1 answer
What is lang in laravel
PHP Laravel
1 vote211 views2 answers
Laravel route group middleware prefix
PHP Laravel