public QueryAggregateInterface::execute()
Executes the aggregate query.
$result = $query
->aggregate('nid', 'count')
->condition('status', 1)
->groupby('type')
->executeAggregate();
Will return:
$result[0] = array('count_nid' => 3, 'type' => 'page');
$result[1] = array('count_nid' => 1, 'type' => 'poll');
$result[2] = array('count_nid' => 4, 'type' => 'story');
Return value
array A list of result row arrays. Each result row contains the aggregate result