How to count group by rows in rails?

Question

When i use User.count(:all, :group => "name"), i got multi rows, but it's not i want, what i want is the count of the rows, how can I do it?

Answer 1

1. User.count will give you the total number of users and translates to the following SQL: SELECT count(*) AS count_all FROM "users"
2. User.count(:all, :group => 'name') will give you the list of unique names, along with their counts, and translates to this SQL: SELECT count(*) AS count_all, name AS name FROM "users" GROUP BY name

I suspect you want option 1 above, but I'm not clear on what exactly you want/need.

Answer 2

Try using User.find(:all, :group => "name").count

Good luck!

Answer 3

Probably you want to count the distinct name of the user?

User.count(:name, :distinct => true)

would return 3 if you have user with name John, John, Jane, Joey (for example) in the database.

 ________
| name   |
|--------|
| John   |
| John   |
| Jane   |
| Joey   |
|________|