Question

帮我把一个sql语句改成HQL语句，谢谢！！！

String sql = "select comName,count(case when patSex='男' then 1 end) as sumsexMen,count(case when patSex='女' then 1 end) as sumsexwomen from Patient group by patComName having patComName="+m+""；

Answer 1

Patient为实体映射类，hql如下，望采纳，谢谢：
String hql = "select t.comName,sum(case when t.patSex='男' then 1 else 0 end) as sumsexMen,sum(case when t.patSex='女' then 1 else 0 end) as sumsexwomen from Patient t group by t.patComName having t.patComName="+m+"";