Questo contenuto non è disponibile nella lingua selezionata.

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 Section 14.19, “Row Value Constructor Syntax” for further information.

Report a bug

Torna in cima

Questo contenuto non è disponibile nella lingua selezionata.

14.14. Subqueries

Formazione

Prova, acquista e vendi

Community

Informazioni sulla documentazione di Red Hat

Rendiamo l’open source più inclusivo

Informazioni su Red Hat

Theme

Red Hat legal and privacy links

Red Hat legal and privacy links