I need to have the below query in hql but i can not do it
Can anyone help please
thanks

select top(10)
c.*,
es = (select count(*) from EN e where e.contestid = c.id and e.status = 'app')
from con c
where status = 'oe'
and cast = 'P'
and choice = 'Sp'
order by
(select count(*) from EN e where e.conid = c.id and e.status = 'app') desc

I know that you can't do session.CreateQuery("select top(10) ...").List() Instead do session.CreateQuery("select ...").SetMaxResults(10).List()

I'm not sure about the rest of it, but that is the one thing that stands out to me.