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

0 vote233 views1 answer
Mysqldump ignore table
SQL
0 vote246 views1 answer
Oracle sql add column auto generated value
SQL
0 vote268 views1 answer
SQLServerException.makeFromDatabaseError
SQL
8 votes229 views2 answers
Phpmyadmin default password
SQL
5 votes243 views2 answers
Postgres update with if condition query
SQL
0 vote238 views1 answer
Sql values not in another table
SQL
0 vote239 views1 answer
Postgresql function ROUND
SQL
9 votes263 views3 answers
Date format in sql
SQL
-1 vote235 views2 answers
Postgresql get last 10 records
SQL
2 votes241 views1 answer
Oracle apex list connected users
SQL