The query builder also provides a variety of aggregate methods such as count
, max
, min
, and sum
. You may call any of these methods after constructing your query:
var getResults = query.from('users').count();writeDump(getResults);
var getResults = query.from('users').max('age');writeDump(getResults);
var getResults = query.from('users').min('age');writeDump(getResults);
Of course, you may combine these methods with other clauses:
var getResults = query.from('users').where('active', '=', 1).max('age');writeDump(getResults);