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

1 vote204 views2 answers
Oracle 18c xe ORA-65096
SQL
19 votes182 views6 answers
Laravel sql query
SQL
0 vote184 views1 answer
Sql find gaps in date ranges
SQL
2 votes180 views1 answer
Check isolation level in mysql
SQL
3 votes183 views2 answers
Get current year sql
SQL
1 vote261 views1 answer
Oracle previous year
SQL
0 vote176 views1 answer
List column names of multiple tables psql
SQL
3 votes172 views2 answers
To_char oracle
SQL
0 vote191 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
0 vote173 views1 answer
Export partttion and import in oracle
SQL