Hi, I have the following SQL.

select temp
from
( select list.id,
list.name,
list.address
from User list) asl


How do I implement it using HQL?? I have the following errors:
org.hibernate.QueryException: in expected: SELECT

Try using an IN clause like:

select list.id, list.name, list.address from User list where list.id IN (select id from User)

Thank you sooooo much!!!
I am gonna give it a try!!

See documentation Hibernate http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html/queryhql.html#queryhql-subqueries .
Subqueries are only allowed in SELECT or WHERE .