ActiveRecord查询

Question

有人知道如何使用ActiveRecord而不是SQL创建此查询吗？

@leaderboard = ActiveRecord::Base.connection.execute("SELECT name, street, town, county,        avg(volume_used)  FROM `DBName`.`events
join DBName.households on idhouseholds = events.household_id 
group by household_id
order by volume_used ASC;");

Answer 1

不如..。

@leaderboard = Event.select([:name,:street,:town,:county,'avg(volume_used) as avg_used']).joins(:households).group('events.household_id').order('volume_used asc')

假设您所说的idhouseholds实际上是指households.id，并且您想要按您选择的聚合平均字段进行排序。