Home » Search

About aggregate

1-10 of 30Refresh
Manual
133

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
40

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
FAQ
28

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
28

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
28

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
28

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

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

Group by: list if no aggregate function is specified

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

Problem of query With an aggregate function

Problem of query With an aggregate function
Manual
20

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