Home » Search

About aggregate

1-10 of 30Refresh
Manual
144

GROUP BY and HAVING clauses

(no Aggregates) The following query groups all the countries by their first letter: SELECT SUBSTRING(c ... : The properties that are used for grouping (each group has unique value combination). Aggregate calculations ... . The aggregate calculation gives the GROUP BY clause its power. Actually, without aggregate
Result
43

ObjectDB Object Database Features

attributes, grouping queries and aggregate queries) which are usually missing from Object Oriented ... inside embedded objects are indexable. Indices are also used for fast ordering and aggregate calculations ... ). GROUP BY (including HAVING and aggregates). ORDER BY (including ASC, DESC). Aggregates (COUNT, SUM
Forum
31

Does aggregate function "greatest" work on entity objects?

Does aggregate function "greatest" work on entity objects? do not come to the function "compareTo" @Entity public class ChatHistoryItem extends AbstractObject implements Comparable { private static final long serialVersionUID = 1L; @Override public int compareTo(Object t
Forum
31

Performance issues on aggregate query

we are using this aggregate query to collect some data: select p3.doubleValue,c1.classIdentifier,c1.objectName,sum(p4.doubleValue),sum(p4.doubleValue*p5.doubleValue),0,p7.doubleValue,p3.name,count(o) from ObjectNode o INNER JOIN o.properties p1 INNER JOIN o.properties p2  INNER JOIN o.properties p3
FAQ
30

Is ObjectDB better than competing object databases?

that an essential feature is missing. For example, some competing products do not support aggregate queries (max, min, count, sum and avg). ObjectDB supports rich queries, including aggregate queries
Manual
30

Running JPA Queries

object is expected. The following aggregate query always returns a single result object, which is a Long ... countryCount = (Long)query.getSingleResult(); An aggregate COUNT query always returns one result, by
Forum
29

Group by: list if no aggregate function is specified

Group by: list if no aggregate function is specified
Forum
29

Problem of query With an aggregate function

Problem of query With an aggregate function
JPA Doc
29

javax.persistence.criteria.CriteriaBuilder

.0 Expression avg( Expression x) Create an aggregate expression applying the avg operation. Create an aggregate expression applying the avg operation. Parameters: x - expression representing ... item Since: JPA 2.0 Expression count( Expression x) Create an aggregate expression applying
Manual
21

Numbers in JPQL and Criteria Queries

Numeric 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