How to use SUM aggregate function in queries with Lithium PHP framework

Question

How to use SUM aggregate function in queries with Lithium PHP framework.

I wanted to fetch sum of a column value. How to do this in Lithium Frame work.

Thanks,

score 4 · Accepted Answer · answered Aug 10 '15 at 14:18

4

I got answer of question. Posting here now.

'fields' => 'SUM(quantity) AS total',

Where 'quantity' is column name.

Thanks,

answered Aug 10 '15 at 14:18

Yogesh

1

You can also do `'fields' => ['SUM(quantity) AS total', ...]` to include other fields as well. – Nate Abele Aug 11 '15 at 13:52

1 Answers1