SQL是这样的:
SELECT A.PP1, A.PP2 FROM TABLE_1 A ,
(SELECT MAX(PP3) AS NEW_PP3, PP1, PP2 FROM TABLE_1
GROUP BY PP1, PP2) B
WHERE A.PP3 = B.NEW_PP3
AND A.PP1 = B.PP1
AND A.PP2 = B.PP2
如何转化成hql?我试了两天了,都要报错。郁闷得很!初来乍到,还没有分,希望大虾们见谅!
SELECT A.PP1, A.PP2 FROM TABLE_1 A ,
(SELECT MAX(PP3) AS NEW_PP3, PP1, PP2 FROM TABLE_1
GROUP BY PP1, PP2) B
WHERE A.PP3 = B.NEW_PP3
AND A.PP1 = B.PP1
AND A.PP2 = B.PP2
如何转化成hql?我试了两天了,都要报错。郁闷得很!初来乍到,还没有分,希望大虾们见谅!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货