在JPA查询中使用groupby和having

终于找到了解决办法:

select p from Person p
where p.email in (
    select q.email
    from Person q
    group by q.email having count(q.email)>1)
order by p.email, p.id

this link ,这里解释了JPA SELECT查询的一般结构:

SELECT ... FROM ...
[WHERE ...]
[GROUP BY ... [HAVING ...]]
[ORDER BY ...]