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 [email protected]

_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Reply via email to