Hi!

I have this query:
select count(job_id) from (select job_id from life where job_id=? group by plan_id) as tmptable;

i need to count the amount of plan_id in life where job_id equals to something.

Is there a better way to achieve it with hibernate?

i use createQuery and put the properties of the classes

select count(distinct plan_id) from life where job_id=?

thanks!
it works!