KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a Mail model with the following schema: t.string "mail" t.integer "country" t.boolean "validated" t.datetime "created_at" t.datetime "updated_at" And I want to find the top 5 countries in the database, so i go ahead and type @top5 = Mail.find(:all,:group => 'country',:conditions => [ "validated = ?" , "t" ], :limit => 5 ) This will tell me the groups(i need an order by i dont know how to write) @top5 = Mail.count(:all,:group => 'country',:conditions => [ "validated = ?" , "t" ], :limit => 5 ) This will tell me how many mails are in each group Im wondering if i can group and count in just one go
Tags (comma-separated)
Save Edits
Cancel