Forum Multiple aggregates in one query

russdirks

posted 10 years ago

Database

Last updated 2 years ago.

jarektkaczyk

replied 10 years ago

Solution

Model::selectRaw('count(*), min(some_field) as someMin, max(another_field) as someMax')->first();
// or in this case maybe better query builder instead of Eloquent:
DB::table('someTable')->selectRaw('count(*), min(some_field) as someMin, max(another_field) as someMax')->first();

Last updated 2 years ago.

russdirks

replied 10 years ago

Thanks. I knew about selectRaw but was wondering if there was some way a little more structured. It would be nice if the aggregate functions would return a Builder object so you could chain them together.

Last updated 2 years ago.