ZF2 - How can I do Aggregate functions in a Select?

3motronik

New Member
Converting one of my applications from procedural to ZF2 and am copying across the SQL. I'm adding pagination so need to use \[code\]Zend\Db\Sql\Select\[/code\]. I've got a database which orders how well users are doing and need to use Aggregate functions but can't see anything in the documentation or code about it.I have \[code\]SUM()\[/code\] and \[code\]COUNT()\[/code\] that I need to use in my query for a long list of users (so can't just do a separate one for each row)Any ideas?
 
Top