Question

帮我看看这条JPA 语句为什会报错误？

select insid, min(allAreaId), max(allAreaId) from (select insid, allAreaId from TbltAllareaHstPK where status = '0' group by insid, allAreaId having count(1) > 1) as a group by insid

Answer 1

看得头都大了。。你能不能格式化排好了再粘贴上来？用图片都行

追问

select insid, min(allAreaId), max(allAreaId)

from (select insid, allAreaId from

TbltAllareaHstPK where status = '0'

group by insid, allAreaId

having count(1) > 1) as a

group by insid

追答

最后的group by insid少了个allAreaId

追问

你说的不对吧！！我这条语句在mysql 里运行可以呀！！