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

2 votes152 views1 answer
Get name custom post type wordpress
PHP Wordpress
0 vote982 views1 answer
Wp php get rows number from mysql
PHP
0 vote135 views3 answers
Method put laravel
PHP
0 vote188 views1 answer
How to make core controller codeigniter 3 more than 1
PHP CodeIgniter
5 votes153 views1 answer
Laravel rate limit
PHP
3 votes149 views3 answers
PHP time limit (max_execution_time):
PHP
0 vote225 views1 answer
At C:\Users\Kamyar\web-pages\telebot\vendor\symfony\process\Pipes\WindowsPipes.php:63 laravel error
PHP Symfony
0 vote142 views2 answers
Show number 1 as 00001 laravel
PHP
0 vote132 views1 answer
Wp change num words exerpct
PHP
0 vote146 views1 answer
Handling deadlocks laravel
PHP Laravel