HQL中的子查询

//子查询
@org.junit.Test

	public void subQuery(){
		session=HibernateUtil.getSession();
		hql="from Emp where sal<(select avg(e.sal) from Emp e) order by sal desc";
		List<Emp> elist=session.createQuery(hql).list();
		for(Emp e:elist){
			System.out.println(e.getEname()+" : "+e.getSal());			
		}
		HibernateUtil.closeSession();
	}