Rails: select unique values from a column

by 
Model.select(:rating)

The result of this is a collection of Model objects. Not plain ratings. And from uniq‘s point of view, they are completely different. You can use this:

Model.select(:rating).map(&:rating).uniq

or this (most efficient):

Model.uniq.pluck(:rating)

Rails 5+

Model.distinct.pluck(:rating)

Update

Apparently, as of rails 5.0.0.1, it works only on “top level” queries, like above. Doesn’t work on collection proxies (“has_many” relations, for example).

Address.distinct.pluck(:city) # => ['Moscow']
user.addresses.distinct.pluck(:city) # => ['Moscow', 'Moscow', 'Moscow']

In this case, deduplicate after the query

user.addresses.pluck(:city).uniq # => ['Moscow']

More Related Contents:

  1. Is there a way to get a collection of all the Models in your Rails app?
  2. Case-insensitive search in Rails model
  3. Rails model without database
  4. ActiveRecord OR query Hash notation
  5. ActiveRecord, has_many :through, and Polymorphic Associations
  6. Using Rails serialize to save hash to database
  7. Rails 3: Get Random Record
  8. Clean way to find ActiveRecord objects by id in the order specified
  9. Altering the primary key in Rails to be a string
  10. What does inverse_of do? What SQL does it generate?
  11. Overriding id on create in ActiveRecord
  12. How do i work with two different databases in rails with active records?
  13. Rails 3 – select with Include?
  14. belongs_to through associations
  15. Check if record exists from controller in Rails
  16. rails dates with json
  17. How do you discover model attributes in Rails?
  18. What’s the difference between belongs_to and has_one?
  19. Renaming the created_at, updated_at columns of ActiveRecord/Rails
  20. How do rails association methods work?
  21. Grouping by week/month/etc & ActiveRecord?
  22. ActiveRecord serialize using JSON instead of YAML
  23. How to implement Active Record inheritance in Ruby on Rails?
  24. Store the day of the week and time?
  25. How to show SQL queries run in the Rails console?
  26. Non persistent ActiveRecord model attributes
  27. Rails: Overriding ActiveRecord association method
  28. How do I avoid a race condition in my Rails app?
  29. How can I use ActiveRecord on a database that has a column named ‘valid’? (DangerousAttributeError)
  30. Specifying column name in a “references” migration

Leave a Comment