日期:2014-05-17  浏览次数:20531 次

hibernate 查询 各位大仙帮忙改改 谢了~~~
query=session.createQuery("from Seedlingforecast aps where fid in(select min(fid) from Seedlingforecast group by (aps.pest.pno and aps.countryseedling.csno))");

------解决方案--------------------
FROM Event as t where t.id in (SELECT min(t1.id) from Event as t1 group by t1.date,t1.title)
类似的没有问题啊
from Seedlingforecast aps where aps.fid in(select min(aps1.fid) from Seedlingforecast aps1 group by aps1.pest.pno,aps1.countryseedling.csno)