Is it possible to do this in one search: select count(1), sum(field1) from table where condition group by field2


(Makeyang) #1

without count(1), it is sample, but is it possible if with count and do it in one search?


(Nik Everett) #2

See aggregations. They do exactly this.


(system) #3