How to use aggregation SQL functions with CakePHP

Submitted by Derick Ng on 11 September 2009 - 2:34am

Have you ever wondering how to find MAX, MIN or AVG of a database table column in CakePHP way? Well I haven’t since yesterday. The solution is quite simple and obvious.
Lets say you want to show the average views per post (in the example we have the views field in every post).
The SQL should be [...]