Group, count, having, and order by in Rails December 12, 2023 by Tarik Try something like: Person.select("id, age").group(:id, :age).having("count(id) > 1").order("age desc")