Can HQL Select on the result set of another query? For example:
SELECT COUNT(*) FROM (SELECT * FROM Table)
I can do it in SQL but when I tried like above in HQL, it just showed me syntax error "unexpected token: ( near line 1, column 22 ..."