14.7. Aggregate functions

HQL queries can even return the results of aggregate functions on properties:

select avg(cat.weight), sum(cat.weight), max(cat.weight), count(cat)
from Cat cat

select avg(cat.weight), sum(cat.weight), max(cat.weight), count(cat)
from Cat cat

Copy to Clipboard

Toggle word wrap

The supported aggregate functions are:

You can use arithmetic operators, concatenation, and recognized SQL functions in the select clause:

select cat.weight + sum(kitten.weight)
from Cat cat
    join cat.kittens kitten
group by cat.id, cat.weight

select cat.weight + sum(kitten.weight)
from Cat cat
    join cat.kittens kitten
group by cat.id, cat.weight

Copy to Clipboard

Toggle word wrap

select firstName||' '||initial||' '||upper(lastName) from Person

select firstName||' '||initial||' '||upper(lastName) from Person

Copy to Clipboard

Toggle word wrap

The distinct and all keywords can be used and have the same semantics as in SQL.

select distinct cat.name from Cat cat

select count(distinct cat.name), count(cat) from Cat cat

select distinct cat.name from Cat cat

select count(distinct cat.name), count(cat) from Cat cat

Copy to Clipboard

Toggle word wrap