使用分组依据并包含在JPA查询中 [英] Using group by and having in a JPA query

问题描述

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

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

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

推荐答案

最终找到了解决方案:

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

这篇关于使用分组依据并包含在JPA查询中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！