이 콘텐츠는 선택한 언어로 제공되지 않습니다.

14.14. Subqueries

For databases that support subselects, Hibernate supports subqueries within queries. A subquery must be surrounded by parentheses (often by an SQL aggregate function call). Even correlated subqueries (subqueries that refer to an alias in the outer query) are allowed.

from Cat as fatcat
where fatcat.weight > (
    select avg(cat.weight) from DomesticCat cat
)

from Cat as fatcat
where fatcat.weight > (
    select avg(cat.weight) from DomesticCat cat
)

Copy to Clipboard

Toggle word wrap

from DomesticCat as cat
where cat.name = some (
    select name.nickName from Name as name
)

from DomesticCat as cat
where cat.name = some (
    select name.nickName from Name as name
)

Copy to Clipboard

Toggle word wrap

from Cat as cat
where not exists (
    from Cat as mate where mate.mate = cat
)

from Cat as cat
where not exists (
    from Cat as mate where mate.mate = cat
)

Copy to Clipboard

Toggle word wrap

from DomesticCat as cat
where cat.name not in (
    select name.nickName from Name as name
)

from DomesticCat as cat
where cat.name not in (
    select name.nickName from Name as name
)

Copy to Clipboard

Toggle word wrap

select cat.id, (select max(kit.weight) from cat.kitten kit)
from Cat as cat

select cat.id, (select max(kit.weight) from cat.kitten kit)
from Cat as cat

Copy to Clipboard

Toggle word wrap

Note that HQL subqueries can occur only in the select or where clauses.

Note that subqueries can also utilize row value constructor syntax. Refer to the "Row Value Constructor Syntax" section for further information.

Report a bug

맨 위로 이동

이 콘텐츠는 선택한 언어로 제공되지 않습니다.

14.14. Subqueries

자세한 정보

평가판, 구매 및 판매

커뮤니티

Red Hat 문서 정보

보다 포괄적 수용을 위한 오픈 소스 용어 교체

Red Hat 소개

Theme

Red Hat legal and privacy links

Red Hat legal and privacy links