About aggregate

21-30 of 33Refresh
JPA Doc
5

least(x)

Method javax.persistence.criteria.CriteriaBuilder Expression least(   Expression 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
JPA Doc
5

max(x)

Method javax.persistence.criteria.CriteriaBuilder Expression max(   Expression 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
JPA Doc
5

min(x)

Method javax.persistence.criteria.CriteriaBuilder Expression min(   Expression 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
JDO Doc
5

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
JPA Doc
5

sum(x)

Method javax.persistence.criteria.CriteriaBuilder Expression sum(   Expression x ) Create an aggregate expression applying the sum operation. Parameters: x - expression representing input value to sum operation Returns: sum expression Since: JPA 2.0
JPA Doc
5

sumAsDouble(x)

Method javax.persistence.criteria.CriteriaBuilder Expression sumAsDouble(   Expression x ) Create an aggregate expression applying the sum operation to a Float-valued expression, returning a Double result. Parameters: x - expression representing input value to sum operation Returns: sum expression Since: JPA 2.0
JPA Doc
5

sumAsLong(x)

Method javax.persistence.criteria.CriteriaBuilder Expression sumAsLong(   Expression 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
Issue
3

Issue with UPPER ?

--------------------- Evaluate aggregate expressions:   count($1). Step 11: Apply selection ... aggregate expressions:   count($1). Step 11: Apply selection ----------------------- Apply selection ... results --------------------- Evaluate aggregate expressions:   count($1). Step 11: Apply
Forum
2

How to query for list of lists ?

.util.List' for an aggregate query at com.objectdb.o.MSG.d(MSG.java:61) at com.objectdb.o.QRC.G(QRC ... expression 'java.util.List' for an aggregate query" Class: @Entity @Table(name = "pulseDataWareHouse
Forum
2

IN expression in a Criteria Query

result expression 'a' for an aggregate query at com.objectdb.o.MSG.d(MSG.java:61) at com.objectdb.o ... that are used for grouping (each group has unique value combination). Aggregate calculations (count, sum