Home » Search

About aggregate

21-30 of 30Refresh
JDO Doc
6

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
6

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
6

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
6

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
Forum
2

composite index not used in query

.classIdentifier='(TC)'). Step 4: Group results --------------------- Evaluate aggregate expressions
Forum
2

Queries are slow on a large database

for aggregate 'count' (error 743) (position 0) at com.objectdb.jdo.JdoQuery.execute0(JdoQuery.java:840
Issue
2

Wrong type on SUM function

Hello, I have a problem when I run this aggregation query: Query q = em.createQuery(         "SELECT cc.totalCC.moneda, SUM(cc.totalCC.importe) FROM ComprobanteContable cc " +         "WHERE cc.cuenta=:cuenta GROUP BY cc.totalCC.moneda"); List resultList = q.setParameter("cuenta