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();    }