select count(*) from (select count(*) from message as msg where msg.toUid=1 and msg.toDelFlag=0 group by msg.relateIds) m select count(*) from (select count(*) from Message as msg where msg.toUid=:id and msg.toDelFlag=0 group by msg.relateIds) as m
我不清楚这两句sql是不是应该有区别,但我对第二句中的msg.toUid=:id有些疑问。
我不清楚这两句sql是不是应该有区别,但我对第二句中的msg.toUid=:id有些疑问。
比如:
Query query = session.createQuery(hql);
query.setInteger("id",1);
select count(*) from (select count(*) from Message as msg where msg.toUid=:id and msg.toDelFlag=0 group by msg.relateIds) as m
怎么报错的是:
-org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: ( near line 1, column 22 [select count(*) from (select count(msg.*) from为什么??
但为啥外面还套个select count(*) 啊?