Laravel Eloquent: sum with groupBy

by 
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,
  ...
)

Or this way (which I wouldn’t use, since it won’t be actual ORM result):

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

// returns collection of Document pseudo models with additional sum field

More Related Contents:

  1. How to select from subquery using Laravel Query Builder?
  2. query sql between two tables [duplicate]
  3. How does database indexing work? [closed]
  4. SQL Server – Best way to get identity of inserted row?
  5. How do I update if exists, insert if not (AKA “upsert” or “merge”) in MySQL?
  6. PostgreSQL “Column does not exist” but it actually does
  7. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  8. How to pass parameters to query?
  9. Fetch the row which has the Max value for a column
  10. Is the NOLOCK (Sql Server hint) bad practice?
  11. Creating table names that are reserved words/keywords in MS SQL Server [closed]
  12. SQL: find missing IDs in a table
  13. Pass table as parameter into sql server UDF
  14. There are no primary or candidate keys in the referenced table that match the referencing column list in the foreign key
  15. SQL to generate a list of numbers from 1 to 100
  16. How to drop SQL default constraint without knowing its name?
  17. Maintaining order in MySQL “IN” query
  18. Postgres analogue to CROSS APPLY in SQL Server
  19. Is it possible to delete from multiple tables in the same SQL statement?
  20. SQL: How to properly check if a record exists
  21. How to return the output of stored procedure into a variable in sql server
  22. How to select multiple rows filled with constants?
  23. How to select only the first rows for each unique value of a column?
  24. Modify Default value in SQL Server
  25. Which datatype should be used for currency?
  26. How to return two columns with function
  27. Regular expression to match common SQL syntax?
  28. SQL server join tables and pivot
  29. SQL: How do you select only groups that do not contain a certain value?
  30. How do I compare 2 rows from the same table (SQL Server)?

Leave a Comment