又发现一条hql没法实现的sql

posted by David Chen at July 18, 2009, 6:03 AM    

hql毕竟有限制，有很多sql不能完成成功模拟，下面是又发现的一句

sql: select tmp.* from (select t.* from student_class_info t order by t.student_cd desc,t.sci_id desc) tmp
group by tmp.student_cd order by tmp.sci_id desc;

hql : from (from bean) as tmp group by tmp.prop1 order by tmp.prop2;
// 不行,無法執行.

改一種寫法:
select t1.* from student_class_info t inner join (select tmp.* from student_class_info tmp order by
tmp.sci_id desc) as t1 on t1.sci_id=t.sci_id group BY t1.student_cd order by t.sci_id desc;

hql : 忘了,反正也不行..