2 u012953466 u012953466 于 2016.03.10 14:49 提问

sql语句转hibernate hql语句

sql语句为select * from (select location_id,region_code,county_name,count(region_code) as countKKou from mon_location where longitude !=0.0 and region_code in ('370901') GROUP BY region_code) as teb LEFT JOIN mon_region as r on teb.region_code = r.code ;
求hql语句
其中sql
select location_id,region_code,county_name,count(region_code) as countKKou from mon_location where longitude !=0.0 and region_code in ('370901') GROUP BY region_code

已经转化为select new com.yisa.map.domain.LocationLocation(m.location_id,count(m.region_code) as countKKou,m.region_code,m.county_name) from LocationVo as m where m.longitude !=0.0 and m.region_code in ('370901') GROUP BY m.region_code

Csdn user default icon
上传中...
上传图片
插入图片
准确详细的回答,更有利于被提问者采纳,从而获得C币。复制、灌水、广告等回答会被删除,是时候展现真正的技术了!