Hi

I want to write a hql ( query in hibernate ) , My problem is that in my one query the result of that query is come using distinct , not i want to sum of one field carried out from that distinct query but it also distinct in sum method too.

Can i use sub table in hql e.g inner join (select * from ....). ?

So how can i solve this .

Hi,

Instead of using DISTINCT,
u can solve your problem with Group By clause aand Aggregate function.


Like ,
select <<sum(salary)>> from <<emp>>
group by <<Grade>>


Hope this help you !!