Counting a values in a column

[eluser]Chathuranga Tennakoon[/eluser]
you can do this without active query as well.

Code:

$this->db->query('select model, sum(Amount) as Total from make group by model');