ActiveRecord-Query-Interface–Ruby-On-Rails

distinct

distinct Specifies whether the records should be unique or not.

Example:

If you want to remove duplicates from a result, you can use .distinct()  

Customers.select(:country).distinct

  This queries the database as follows:  

SELECT DISTINCT “customers”.”country” FROM “customers”

.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.

For more information distinct click me!

Thanks For Reading

Leave a Reply

Your email address will not be published. Required fields are marked *