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

9 votes193 views3 answers
$_SESSION php example
PHP
0 vote228 views1 answer
Divide page in pdf with page break using php
PHP
0 vote232 views1 answer
Php afosto / yaac urn:ietf:params:acme:error:malformed 405
PHP
0 vote177 views1 answer
Install laravel jetstream inertia js
PHP
0 vote215 views1 answer
Union of two arrays in php
PHP
0 vote175 views1 answer
Php initialize two dimensional array dynamically
PHP
16 votes200 views6 answers
Php get first key of array
PHP
13 votes186 views6 answers
Route group in laravel
PHP
0 vote216 views1 answer
Year shortcode wordpress
PHP Wordpress
0 vote229 views2 answers
Php mb_convert_encoding utf8 extended
PHP