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 vote95 views1 answer
Ms sql print more than 1 variable
SQL
0 vote176 views2 answers
Suse stop MySQL
SQL
5 votes153 views1 answer
Mysql count newlines in field
SQL
0 vote142 views5 answers
Linq cheat sheet
SQL
5 votes166 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote137 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote148 views1 answer
Postgress append string in select
SQL
0 vote135 views1 answer
Like sql for second letter of the family name
SQL
1 vote141 views3 answers
Execute sp in sql server
SQL
0 vote144 views1 answer
Psql select * from table
SQL