About SUM

11-20 of 32Refresh
Manual
17

FROM clause (JPQL / Criteria API)

, SUBSTRING, SUM, THEN,TRAILING, TRIM, TRUE, TYPE, UNKNOWN, UPDATE, UPPER, VALUE, WHEN, WHERE. JPQL
Manual
17

ORDER BY clause (JPQL / Criteria API)

can order these groups. For example: SELECT c.currency, SUM(c.population) FROM Country c
FAQ
17

Is ObjectDB better than competing object databases?

queries (max, min, count, sum and avg). ObjectDB supports rich queries, including aggregate queries
Manual
17

JPA Query Structure (JPQL / Criteria)

GROUP BY / HAVING (groupBy, having, count, sum, avg, min, max, ...). Criteria ORDER BY (orderBy, Order, asc, desc).
Result
17

ObjectDB Object Database Features [2018-01-27]

). GROUP BY (including HAVING and aggregates). ORDER BY (including ASC, DESC). Aggregates (COUNT, SUM
Result
17

ObjectDB Object Database Features [2018-10-27]

). GROUP BY (including HAVING and aggregates). ORDER BY (including ASC, DESC). Aggregates (COUNT, SUM
Result
17

ObjectDB Object Database Features

and aggregates). ORDER BY (including ASC, DESC). Aggregates (COUNT, SUM, AVG, MAX, MIN). Query
JPA Doc
9

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
9

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

Problem of query With an aggregate function

Hi I would know if this type of query is supported By JPA: select sum(nb1), sum(nb2), sum(nb3 ... > sommeClassesRep(Choix choix) { Query listClassRepHost = em.createQuery("SELECT SUM(h.nb1xx), SUM(h.nb2xx),SUM(h.nb3xx),SUM(h.nb4xx),SUM(h.nb5xx) FROM HttpEntity h WHERE h.host = :host and h.date_http BETWEEN