Re: using aggregate functions in select statements

From: André Luiz N Sousa (andresous..aixaseguros.com.br)
Date: Tue Aug 19 2003 - 18:20:28 EDT

  • Next message: Tore Halset: "update of many to many"

    Hello, Holger,

            Could you send us some useful examples using aggregate functions? Thanks.

            Another question: Does anybody here could list the main differences between the Cayenne and the Hibernate ???

            Thanks again,

            Happy Christmas,

    André Luiz

    ----- Original Message -----
    From: "Holger Hoffstätte" <holge..izards.de>
    To: <cayenne-use..bjectstyle.org>
    Sent: Tuesday, August 19, 2003 3:29 PM
    Subject: Re: using aggregate functions in select statements

    > Martin Dengler wrote:
    > > some questions regarding expression / query API:
    > > does the expression / query API support:
    > >
    > > - aggregate functions (SUM,AVG,MIN,MAX,COUNT) ?
    > > - GROUP BY / HAVING
    > > - INNER JOIN / LEFT/RIGTH OUTER JOIN
    > > - UNION,INTERSECT,MINUS
    > > - Subqueries
    >
    > Some of these are already in there, some are not (I'm reasonably sure
    > subqueries are not). Have a look at Expression and ExpressionFactory.
    > Please note that we do not claim completeness :-)
    >
    > Holger

    This archive was generated by hypermail 2.0.0 : Tue Aug 19 2003 - 18:10:50 EDT