How to get distinct values for non-key column fields in Laravel?

by

You should use groupby. In Query Builder you can do it this way:

$users = DB::table('users')
            ->select('id','name', 'email')
            ->groupBy('name')
            ->get();

More Related Contents:

  1. Laravel – Eloquent “Has”, “With”, “WhereHas” – What do they mean?
  2. Migration: Cannot add foreign key constraint
  3. Laravel Eloquent groupBy() AND also return count of each group
  4. Eloquent Collection: Counting and Detect Empty
  5. Eloquent eager load Order by
  6. Laravel Eloquent vs DB facade: Why use Eloquent and decrease performance? [closed]
  7. Laravel. Use scope() in models with relation
  8. Laravel Eloquent “WHERE NOT IN”
  9. HasManyThrough with one-to-many relationship
  10. Getting just the latest value on a joined table with Eloquent
  11. Laravel Migration Change to Make a Column Nullable
  12. Select Last Row in the Table
  13. How to select specific columns in laravel eloquent
  14. How to access model hasMany Relation with where condition?
  15. Eloquent push() and save() difference
  16. Laravel Eloquent – distinct() and count() not working properly together
  17. Laravel save / update many to many relationship
  18. First Or Create
  19. Laravel: Returning the namespaced owner of a polymorphic relation
  20. How to setup conditional relationship on Eloquent
  21. Polymorphic Eloquent relationships with namespaces
  22. Laravel Eloquent – Where In All
  23. Clone an Eloquent object including all relationships?
  24. Group by not working – Laravel
  25. How to insert multiple rows from a single query using eloquent/fluent
  26. Laravel – Eloquent or Fluent random row
  27. Creating and Update Laravel Eloquent
  28. How to sort a Laravel query builder result by multiple columns?
  29. global variable for all controller and views
  30. Laravel Eloquent: How to get only certain columns from joined tables

Leave a Comment