I am ramu. i am having a problem with group by clause.
my entities are project and bid
my query is
SELECT distinct(p.projectId) FROM Project p JOIN p.bids b GROUP BY p HAVING COUNT(b) > 1
the above query is returning projectid.
but i want to get project object.
for that i have tried like this but not working
SELECT distinct(p) FROM Project p JOIN p.bids b GROUP BY p HAVING COUNT(b) > 1
it is saying not a GROUP BY expression
please help me its very urgent.
please somebody answer can i get the object in select clauuse with group by clause