Plz can any one help me in this query , first i m trying it by HQL
My HQl Query is

String query="select o.keyword,o.overturevolume from OvertureMasterSetter as o where exists (select m.keyword,m.overturevolume from OvertureMasterSetter m where m.prid='"+projectId+"' and
o.overturevolume = m.overturevolume having count(m.overturevolume)>1 )";

Query qr=session.createQuery(query);
List list=qr.list();


when i run this it gives that upexpected token having................but the same query is running in MS Sql Server Query Analyzer and giving result.................i m worried abt it what's wrong i m doing so that the above query in unable to run

Plz help me out in this......
Many many thx

Hi,

I did not understand as to why are you using two select queries where we can achieve the same with only one, try the following:

select o.keyword,o.overturevolume from OvertureMasterSetter as o
where o.prid='"+projectId+"' and having count(o.overturevolume)>1

The reason for unexpected token in the query might be because of
OvertureMasterSetter m instead should be OvertureMasterSetter as m

Please try.

Thanks,
Lakshmi