select a.userid,count(distinct b.userid) from [user] a join info b on a.userid=b.userid group by a.userid
麻烦一下能用hql语句写一下吗 谢谢了
也不知道对不对 select count(*) from user inner join info on user.userid=info.userid where .....自己测试下
麻烦用hql语句写一下 谢谢了
没什么区别 自己看着改呗 ,也没用过hql 但是差不多
select count(distinct userid) from info,hql是什么,不懂,求教
这句MySql语句确实能查出来 但是hql语句不能读取on,哎 烦人啊
我已经做出来了 谢谢前面几位了 StringBuffer hql = new StringBuffer("from User as a where a.userid in(select distinct b.users.id from Info as b)"); 这个users是外键
我的那个也能查出来的 from User as a where a.userid in(select distinct b.users.id from Info as b 和select count(*) from user inner join info on user.userid=info.userid 一样滴 可以好好看下hql的定义
a.userid,count(distinct b.userid)
from
[user] a join info b
on
a.userid=b.userid
group by
a.userid
StringBuffer hql = new StringBuffer("from User as a where a.userid in(select distinct b.users.id from Info as b)");
这个users是外键