method
count_by_sql
v6.0.0 -
Show latest stable
- Class:
ActiveRecord::Querying
count_by_sql(sql)public
Returns the result of an SQL statement that should only include a COUNT(*) in the SELECT part. The use of this method should be restricted to complicated SQL queries that can’t be executed using the ActiveRecord::Calculations class methods. Look into those before using this method, as it could lock you into a specific database engine or require a code change to switch database engines.
Product.count_by_sql "SELECT COUNT(*) FROM sales s, customers c WHERE s.customer_id = c.id" # => 12
Parameters
-
sql - An SQL statement which should return a count query from the database, see the example above.