Home » Search

About SUM

11-20 of 30Refresh
FAQ
19

Is ObjectDB better than competing object databases?

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

JPA Query Expressions (JPQL / Criteria)

, navigation and types (get, type). Arithmetic expressions (sum, diff, prod, quot, mod, abs, neg
Manual
19

JPA Query Structure (JPQL / Criteria)

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

ORDER BY clause (JPQL / Criteria API)

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

ObjectDB Object Database Features

). GROUP BY (including HAVING and aggregates). ORDER BY (including ASC, DESC). Aggregates (COUNT, SUM
JPA Doc
10

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
10

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

find() cost unreasonable time!

@ 0.000000 The sum : 18 Class of Nodes: @Entity @Inheritance(strategy=InheritanceType.JOINED ... ", (System.currentTimeMillis()-start)/1000f);   }   System.out.printf("The sum : %d %n", iSum ... )/1000f);   }   System.out.printf("The sum : %d %n", iSum);   System.out.println(); } public static
Forum
3

How to convert a boolean to an int in the query?

, approvePhoneNumber, .... because the parameters equivalent. I want to sort them in the query by their sum ... for your help Consider adding an int field to your entity class, that will sum ... .orderBy(cb.desc(cb.sum(intApproveEmail, intApprovePhoneNumber))); query = em.createQuery(q