14.13. 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. See Section 14.18, “Row value constructor syntax” for more information.

Nach oben

Dieser Inhalt ist in der von Ihnen ausgewählten Sprache nicht verfügbar.

14.13. Subqueries

Lernen

Testen, kaufen und verkaufen

Communitys

Über Red Hat Dokumentation

Mehr Inklusion in Open Source

Über Red Hat

Theme

Red Hat legal and privacy links

Red Hat legal and privacy links