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

1.	ActiveRecord
2.	Array
3.	CGI
4.	Class
5.	Collections
6.	Database
7.	Date
8.	Design Patterns
9.	Development
10.	File Directory
11.	GUI
12.	Hash
13.	Language Basics
14.	Method
15.	Network
16.	Number
17.	Rails
18.	Range
19.	Reflection
20.	Statement
21.	String
22.	Threads
23.	Time
24.	Tk
25.	Unit Test
26.	Windows Platform
27.	XML

Ruby » ActiveRecord » 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

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.