读书人

hibernate 查询 各位大仙帮忙改改 谢

发布时间: 2012-04-12 15:46:35 作者: rapoo

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)

读书人网 >Java Web开发

热点推荐