About aggregate

GROUP BY and HAVING clauses

Explains how to use the GROUP BY and HAVING clauses in a JPA/JPQL query.... BY as DISTINCT (no Aggregates) GROUP BY with Aggregate Functions GROUP BY with HAVING Global ... (each group has unique value combination). Aggregate calculations (count, sum, avg, max, min) that are carried out on all ...

ObjectDB Object Database Features

ObjectDB provides a rich set of features, many of them as the result of supporting the JPA and JDO APIs.... keys, automatically generated values, grouping queries and aggregate queries) but are usually missing from Object Oriented Databases - are ... Indexes are also used for fast ordering and aggregate calculations . ...

sum(x)

Create an aggregate expression applying the sum operation.(Method of javax.persistence.criteria.CriteriaBuilder)

javax.persistence.criteria.CriteriaBuilder

Used to construct criteria queries, compound selections, expressions, predicates, orderings.(Interface of JPA)

count(x)

Create an aggregate expression applying the count operation.(Method of javax.persistence.criteria.CriteriaBuilder)

avg(x)

Create an aggregate expression applying the avg operation.(Method of javax.persistence.criteria.CriteriaBuilder)

min(x)

Create an aggregate expression applying the numerical min operation.(Method of javax.persistence.criteria.CriteriaBuilder)

max(x)

Create an aggregate expression applying the numerical max operation.(Method of javax.persistence.criteria.CriteriaBuilder)

sumAsLong(x)

Create an aggregate expression applying the sum operation to an Integer-valued expression, returning a Long result.(Method of javax.persistence.criteria.CriteriaBuilder)

sumAsDouble(x)

Create an aggregate expression applying the sum operation to a Float-valued expression, returning a Double result.(Method of javax.persistence.criteria.CriteriaBuilder)