hibernate - 如何在名为query的grails中编写 “not exists”查询？

Question

如何在休眠条件或命名查询中编写“不存在”查询？我正在尝试获取一个命名查询不存在的查询，该查询返回的结果与此Oracle SQL查询相同:

select *
from SCHOOL a
where not exists (select 1
from STUDENT b
where B.SCHOOL_ID=a.id
and B.STATUS_ID not in (0,1,2,3,4))

Answer 1

在HQL中:

select s from School s where not exists (
    select st.id from Student st 
    where st.school = s 
    and st.statusId not in (0,1,2,3,4))