Laravel Eloquent groupBy() AND also return count of each group

by

This is working for me:

$user_info = DB::table('usermetas')
                 ->select('browser', DB::raw('count(*) as total'))
                 ->groupBy('browser')
                 ->get();

More Related Contents:

  1. Migration: Cannot add foreign key constraint
  2. Eloquent Collection: Counting and Detect Empty
  3. Eloquent eager load Order by
  4. Laravel. Use scope() in models with relation
  5. Laravel Eloquent “WHERE NOT IN”
  6. How to access model hasMany Relation with where condition?
  7. Eloquent push() and save() difference
  8. Laravel save / update many to many relationship
  9. First Or Create
  10. Laravel: Returning the namespaced owner of a polymorphic relation
  11. Polymorphic Eloquent relationships with namespaces
  12. Clone an Eloquent object including all relationships?
  13. Laravel – Eloquent “Has”, “With”, “WhereHas” – What do they mean?
  14. Laravel redirect back to original destination after login
  15. How to install Laravel 4 to a web host subfolder without publicly exposing /app/ folder?
  16. How can I resolve “Your requirements could not be resolved to an installable set of packages” error?
  17. Laravel Redirect Back with() Message
  18. Laravel Fluent Query Builder Join with subquery
  19. laravel with() method versus load() method
  20. Laravel Eloquent: How to order results of related models?
  21. Laravel Controller Subfolder routing
  22. How to use paginate() with a having() clause when column does not exist in table
  23. Select Last Row in the Table
  24. How to get distinct values for non-key column fields in Laravel?
  25. Where can I set headers in laravel
  26. What is the difference between queue:work –daemon and queue:listen
  27. How to select specific columns in laravel eloquent
  28. How to setup conditional relationship on Eloquent
  29. Laravel Many to many self referencing table only works one way
  30. Laravel Eloquent – Where In All

Leave a Comment