关于 java:Hibernate 中使用 Criterion 的嵌套查询

select x, y, x
from (select x, y, z from some_table where x between x1 and x2)
where y like ‘y1’
order by z by desc

    DetachedCriteria subCriteria =  
                      DetachedCriteria.forClass(SomeClass.class)
                     .add(Restrictions.between("x","x1","x2"))  
                     .setProjection(Projections.projectionList()
                     .add(Projections.property("x"))
                     .add(Projections.property("y"))
                     .add(Projections.property("z"));

   List<Object[]> results = session
                .createCriteria(Program.class)
                .add(Subqueries.exists(subCriteria))
                .add(Restrictions.like("y","y1"))
                .addOrder(Order.desc("z")).list();