select class.id, class.name, sum(student) from Class class join Student as student where class.id = student.cid group by class order by sum(student.id) desc;
你的hbm.xml是怎样的呀。你用是hql,要把你的mapping文件拿出来看看哟。
回复:#4 hbm.xml没有任何关联。只是简单的ORM
感谢3楼,可以用。不过忘了你一个on 要这样写: select class.id, class.name,sum(student) from Class class join Studentas student on class.id= student.cid groupby class order by sum(student.id) desc;不是sum() 是count()更改完毕 。感谢大家 ALL THANKS
from Class class
join Student as student
where class.id = student.cid
group by class
order by sum(student.id) desc;
hbm.xml没有任何关联。只是简单的ORM
感谢3楼,可以用。不过忘了你一个on 要这样写:
select class.id, class.name,sum(student) from Class class join Studentas student on class.id= student.cid groupby class order by sum(student.id) desc;不是sum() 是count()更改完毕 。感谢大家 ALL THANKS