Question

大神来帮忙把sql转换成hql

SQL:
select role0_.role_id as role1_10_1_, role0_.role_pid as role2_10_1_, role0_.role_name as role3_10_1_, role0_.role_isparent as role4_10_1_, privileges1_.role_id as role2_10_3_, privilege2_.privilege_id as privilege1_3_, privilege2_.privilege_id as privilege1_8_0_, privilege2_.privilege_pid as privilege2_8_0_, privilege2_.privilege_name as privilege3_8_0_, privilege2_.privilege_icon as privilege4_8_0_, privilege2_.privilege_url as privilege5_8_0_, privilege2_.privilege_target as privilege6_8_0_, privilege2_.privilege_isparent as privilege7_8_0_, privilege2_.privilege_type as privilege8_8_0_ from dc_member_role role0_ left outer join dc_member_role_privileges privileges1_ on role0_.role_id=privileges1_.role_id left outer join dc_member_privilege privilege2_ on privileges1_.privilege_id=privilege2_.privilege_id order by privileges1_.privilege_id

Answer 1

给你提点建议,你这个查询不用那么麻烦的,sql不是有group by吗,用那个即可

SELECT merchant_area as name,count(*) as num
FROM merchant
GROUP BY merchant_area

改成HQL为
SELECT m.merchantArea AS name,COUNT(m.ID) AS num FROM Merchant AS m GROUP BY m.merchantArea！

Answer 2

闹呢`
这sql不就是hibernate自己生成的？