How to Use Group in Rails: Syntax and Examples

In Rails, use group with ActiveRecord queries to group records by one or more columns, similar to SQL GROUP BY. For example, Model.group(:column_name) groups records by that column and allows aggregate functions like count or sum on each group.

Syntax

The group method in Rails ActiveRecord groups query results by one or more columns. You can pass a single column name as a symbol or multiple columns as arguments. It works like SQL's GROUP BY clause.

• Model.group(:column) groups by one column.
• Model.group(:col1, :col2) groups by multiple columns.
• Use aggregate methods like count, sum, or average after grouping.

ruby

Model.group(:column_name)
Model.group(:col1, :col2)
Model.group(:column_name).count

Example

This example shows how to group users by their role and count how many users belong to each role.

ruby

class User < ApplicationRecord
  # Assume users table has a 'role' column
end

# Group users by role and count each group
user_counts = User.group(:role).count
puts user_counts

Output

{"admin"=>5, "member"=>20, "guest"=>10}

Common Pitfalls

Common mistakes when using group include:

• Forgetting to use aggregate functions like count or sum after grouping, which returns grouped records but not aggregated data.
• Passing invalid column names or misspelling them causes errors.
• Using group without selecting columns can return unexpected results.

ruby

 # Wrong: group without aggregate
 users = User.group(:role)
 puts users.inspect

 # Right: group with count
 user_counts = User.group(:role).count
 puts user_counts

Quick Reference

Usage	Description
Model.group(:column)	Groups records by one column
Model.group(:col1, :col2)	Groups records by multiple columns
Model.group(:column).count	Counts records in each group
Model.group(:column).sum(:amount)	Sums a column for each group
Model.group(:column).average(:score)	Calculates average per group

Key Takeaways

Use group to group ActiveRecord query results by one or more columns.

Always combine group with aggregate methods like count or sum to get meaningful data.

Pass valid column names as symbols to group to avoid errors.

Grouping without aggregation returns grouped records but not summarized data.

You can group by multiple columns by passing them as arguments or an array.