Rails活动记录查询获取最常见的对象 [英] Rails active record query getting most common objects

问题描述

我正在尝试查询模型以获取我拥有的某些属性的最常见字段

I am trying to query a model to get the most common field of a certain attributeso far I have

 Person.maximum('age')

但是我该如何查询一组最常见的年龄为6岁的年龄. 任何帮助将非常感激. 谢谢

But how do I query a group of lets say 6 of the most common ages. Any help would be much appreciated. thanks

推荐答案

您将必须按年龄将人员分组，然后选择计数最高的组.下面的代码将同时返回年龄和最频繁出现的频率.

You will have to group persons by their ages and pick the group with the highest count. The code below will return both age and frequency of most frequent age.

Person.group('age').order('count_all').limit(1).count

仅获取年龄而不是计数

Person.group('age').order('count(*)').limit(1).pluck(:age).first

这篇关于Rails活动记录查询获取最常见的对象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！