Laravel sum group by

$docs = Document::groupBy('users_editor_id')
   ->selectRaw('sum(no_of_pages) as sum, users_editor_id')
   ->get(); //this return collection 

//In Blade
@foreach($docs as $doc)
	{{$doc->users_editor_id}} >-------< {{$doc->sum}}
@endforeach

Sql select sum group by id laravel

Document::groupBy('users_editor_id')
   ->selectRaw('sum(no_of_pages) as sum, users_editor_id')
   ->pluck('sum','users_editor_id');

   // originally lists(), which was deprecated in favour of pluck in 5.2
   // and dropped completely in 5.3
   // ->lists('sum','users_editor_id');


// returns array like this:
array(
  users_editor_id => sum,
  ...
)

Source: stackoverflow.com

Similar codes

10 votes435 views3 answers
Check count in laravel
PHP Laravel
0 vote454 views1 answer
Delete previous uploaded image when update laravel
PHP Laravel
6 votes345 views2 answers
Laravel migration table column nullable
PHP Laravel
12 votes367 views5 answers
Laravel run single migration
PHP Laravel
0 vote363 views1 answer
Textarea laravel migration
PHP Laravel
4 votes278 views1 answer
Laravel disable register
PHP Laravel
0 vote397 views1 answer
Laravel/framework[v7.29.0, ..., 7.x-dev] require ext-mbstring * -> it is missing from your system. Install or enable PHP's mbstring extension.
PHP Laravel
6 votes329 views1 answer
PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes") laravel 8
PHP Laravel
0 vote404 views10 answers
Event handler with worker laravel
PHP Laravel
0 vote362 views1 answer
How to create a new component in laravel
PHP Laravel