Ruby on Rails - .distinct (or .uniq) ruby on rails- ruby on rails tutorial - rails guides - rails tutorial - ruby rails
- If we want to remove duplicates from a result, we can use .distinct():
Customers.select(:country).distinct
Clicking "Copy Code" button will copy the code into the clipboard - memory. Please paste(Ctrl+V) it in your destination. The code will get pasted. Happy coding from Wikitechy - ruby on rails tutorial - rails guides - ruby rails - rubyonrails - learn ruby on rails - team
This queries the database given below:
SELECT DISTINCT "customers"."country" FROM "customers"
Clicking "Copy Code" button will copy the code into the clipboard - memory. Please paste(Ctrl+V) it in your destination. The code will get pasted. Happy coding from Wikitechy - ruby on rails tutorial - rails guides - ruby rails - rubyonrails - learn ruby on rails - team
- .uniq() has the same effect. With Rails 5.0 it got deprecated and it will be removed from Rails with version 5.1.
- The reason is, that the word unique doesn't have the same meaning as distinct and it can be misleading.
- Furthermore distinct is closer to the SQL syntax.