21 Mar
2016
21 Mar
'16
10:04 a.m.
Hi, Varun! On Mar 21, Varun Gupta wrote:
Hi Sergei,
4) :create an Item_sum_sp to be able to use aggregate stored functions in queries. Does this mean we can have the aggregate stored functions in the SELECT , WHERE etc clauses?can you give me more details about this.
Yes, of course. That's how functions are used, right? :) SELECT AVG(x), COUNT(y), MAX(z) FROM t1 WHERE aaa=12 GROUP BY bbb; for example. Regards, Sergei Chief Architect MariaDB and security@mariadb.org