Re: EJBQL: clause for count() statement?

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Jan 28 2010 - 06:46:55 EST

  • Next message: Andrey Razumovsky: "Re: EJBQL: clause for count() statement?"

    This should work:

        select a, count(p) from Artist a join a.paintings p group by a
    having count(p) > 5

    Andrus

    On Jan 28, 2010, at 12:47 PM, Andrey Razumovsky wrote:

    > Hi,
    >
    > Imagine I need to select all artists with their painting count.
    > That's how I
    > do that
    > select a, count(p) from Artist a inner join a.paintings p group by a
    >
    > I need to select all artists that have >5 paintings... how can I do
    > that? I
    > thought I need something like aliases, but our EJBQL doesn't support
    > it:
    > select a, count(p) AS pCount from Artist a inner join a.paintings p
    > where
    > pCount>5 group by a
    >
    > Is there any way to do that?
    > --
    > Andrey

    This archive was generated by hypermail 2.0.0 : Thu Jan 28 2010 - 06:47:28 EST