Most common value in an active deck

Question

Just wanted to ask if anyone knows how to find the 5 most frequent values in the colomn model for the active record.

eg,

Country.find(:name)

How can I find the 5 most common countries

+3

cj91rs 07 Aug '14 at 9:25

1 answer

jvnill · Accepted Answer · 2014-08-07T09:28:52+0000

Use the following

Country.group(:name).order('count_id DESC').limit(5).count(:id)