Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Rails: sum all column elements where param1 == some value

I want to sum all elements (e.g. price) from table column where some values (type) equal to some param (1):

Table

id type price
-------------
1  1    10
2  1     8
3  2     7
4  1     2

I think, it may be like this:

Table.where(:type => 1). ???

I need to get 20.

like image 337
Oleg Pasko Avatar asked Jul 19 '11 12:07

Oleg Pasko


1 Answers

Table.where(:type => 1).sum(:price)
like image 82
eugen Avatar answered Sep 25 '22 01:09

eugen