select * from VisitRegister vr where vr.registerStatus=0 order by vr.visitCode
这样也不对的 HQL=select * from VisitRegister vr where vr.registerStatus=0 order by vr.visitCode net.sf.hibernate.QueryException: undefined alias: vr [select sum(vr.applicantNumber) ]
from VisitRegister vr where vr.registerStatus=0 order by vr.visitCode
很明显不是这句出的错 你应该还用到查 count 的sql了吧 该哪一句 把order by 语句去掉
你啥数据库呀? 虽然在count的sql中加上order by没啥意义,而且还降低效率,但也不应该出错呀 oracle 10g这个语句没问题的: select count(*) from emp order by empno;
HQL=select * from VisitRegister vr where vr.registerStatus=0 order by vr.visitCode
net.sf.hibernate.QueryException: undefined alias: vr [select sum(vr.applicantNumber) ]
你应该还用到查 count 的sql了吧
该哪一句 把order by 语句去掉
虽然在count的sql中加上order by没啥意义,而且还降低效率,但也不应该出错呀
oracle 10g这个语句没问题的:
select count(*) from emp order by empno;