21 | Numbers in JPQL and Criteria QueriesNumeric values may appear in JPQL queries in many forms: as numeric literals - e.g. 123, -12.5. as parameters - when numeric values are assigned as arguments. as path expressions - in navigation to persistent numeric fields. as aggregate expressions - e.g. COUNT. as collection functions |
21 | Paths and Types in JPQL and Criteria API all these objects (this is an aggregate query with no GROUP BY - all the objects are considered as |
6 | least(x)Method javax.persistence.criteria.CriteriaBuilder Expression<X> least( Expression<X> x ) Create an aggregate expression for finding the least of the values (strings, dates, etc). Parameters: x - expression representing input value to least operation Returns: least expression Since: JPA 2.0 |
6 | avg(x)Method javax.persistence.criteria.CriteriaBuilder Expression<Double> avg( Expression<N> x ) Create an aggregate expression applying the avg operation. Parameters: x - expression representing input value to avg operation Returns: avg expression Since: JPA 2.0 |
6 | min(x)Method javax.persistence.criteria.CriteriaBuilder Expression<N> min( Expression<N> x ) Create an aggregate expression applying the numerical min operation. Parameters: x - expression representing input value to min operation Returns: min expression Since: JPA 2.0 |
6 | max(x)Method javax.persistence.criteria.CriteriaBuilder Expression<N> max( Expression<N> x ) Create an aggregate expression applying the numerical max operation. Parameters: x - expression representing input value to max operation Returns: max expression Since: JPA 2.0 |
6 | sumAsLong(x)Method javax.persistence.criteria.CriteriaBuilder Expression<Long> sumAsLong( Expression<Integer> x ) Create an aggregate expression applying the sum operation to an Integer-valued expression, returning a Long result. Parameters: x - expression representing input value to sum operation Returns: sum expression Since: JPA 2.0 |
1 | javax.jdo.Query to obtain persistent instances, values, and aggregate data from the data store. The PersistenceManager ... must either be an expression contained in the grouping, or an aggregate evaluated once per group. Parameters ... field values (projections) and aggregate function results. Parameters: data - a comma-delimited list |
0 | setResult(data). If set, this query will return expressions, including field values (projections) and aggregate ... , or aggregate functions) to return from this query Since: JDO 2.0 |
0 | setGrouping(group)Method javax.jdo.Query void setGrouping( String group ) Set the grouping expressions, optionally including a "having" clause. When grouping is specified, each result expression must either be an expression contained in the grouping, or an aggregate evaluated once per group. Parameters: group |
