本文介绍了SQL语句,子查询数?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有以下SQL表
部门
|name|employees|员工
|name|gender|type|dead | |John|male |good|yes | |Mary|female|bad |no | |Joe |male |ugly|maybe|我想写一条返回的语句
| type | n of employees | n of male employees | n of departments |我有
SELECT e.type, count(e), count(d) FROM Department d JOIN d.employees e WHERE e.dead = maybe GROUP BY e.type当然,这缺少'n男性雇员'。我被困在这里,因为我不确定在哪里指定附加子句e.gender = male。
That's missing the 'n of male employees', of course. I'm stuck here, since I'm not sure, where to specify the additional clause e.gender = male.
我忘了提及:HQL或标准是很好。
I forgot to mention: HQL or criteria would be nice.
推荐答案仅供参考:
SELECT e.type, count(e), count(d), sum(case when gender = 'male' then 1 else 0 end) from Department d JOIN d.employees e WHERE e.dead = 'maybe' GROUP BY e.type在HQL中工作。谢谢大家!
works in HQL. Thanks everyone!
更多推荐
SQL语句,子查询数?
发布评论