Aggregate function and group by : Map to SQL « ActiveRecord « Ruby






  1. Ruby
  2. ActiveRecord
  3. Map to SQL

Aggregate function and group by


Account.find :all, :select => "COUNT(last_name) AS total, *", :group => "last_name"

which would result in the following SQL:

SELECT COUNT(last_name) AS total, * FROM accounts GROUP BY last_name








Related examples in the same category

1.The :order parameter defines the sorting order.
2.Group by clause
3.Left join
4.Left join on a column
5.Limit offset