Question

这个sql语句怎么转换成Hql语句

SELECT distinct merchant_area as name,(select count(*) from merchant where merchant_area=name) as num
FROM merchant;

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