java 在 JPA 查询中使用 group by 和 have

Using group by and having in a JPA query

提问by Jacob

How would you do the following using the JPA query language?

您将如何使用 JPA 查询语言执行以下操作？

select * from person where email in
(select email from person group by email having count(email)>1)

回答by Jacob

Finally found a solution:

终于找到了解决办法：

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

回答by Cacovsky

From this link, there's a explanation of the general structure of a JPA SELECT Query:

从这个链接，有一个 JPA SELECT 查询的一般结构的解释：

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