qb

Aggregates

Last updated 4 months ago

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);

Retrieving Results

Selects