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.

Volver arriba

Este contenido no está disponible en el idioma seleccionado.

14.13. Subqueries

Aprender

Pruebe, compre y venda

Comunidades

Acerca de la documentación de Red Hat

Hacer que el código abierto sea más inclusivo

Acerca de Red Hat

Theme

Red Hat legal and privacy links

Red Hat legal and privacy links