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
