Home » Search

About GROUP BY

11-20 of 200Refresh
Result
27

ObjectDB Object Database Features

). GROUP BY (including HAVING and aggregates). ORDER BY (including ASC, DESC). Aggregates (COUNT, SUM ... attributes, grouping queries and aggregate queries) which are usually missing from Object Oriented Databases are also supported by ObjectDB. The combination of Object Database features
Forum
27

Group by: list if no aggregate function is specified

Hello! In a query like SELECT parent, children FROM Parent parent LEFT JOIN p.children children GROUP BY parent maybe it would be good if it will return a list of Object[2], where the second object is a list of children of a parent. Because creating a query to get a list of parents, then fetching
Manual
27

Paths and Types in JPQL and Criteria API

counts all these objects (this is an aggregate query with no GROUP BY - all the objects are considered ... classes) are represented in JPQL by the following types of expressions: Variables - FROM ... and functions (e.g. for strings and for numbers), they can be compared by all six comparison operators
JPA Doc
26

groupBy(grouping)

grouping ) Specify the expressions that are used to form groups over the query results. Replaces the previous specified grouping expressions, if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. Parameters: grouping - list of zero or
JPA Doc
26

groupBy(grouping)

Method javax.persistence.criteria.AbstractQuery AbstractQuery groupBy(   Expression... grouping ) Specify the expressions that are used to form groups over the query results. Replaces the previous specified grouping expressions, if any. If no grouping expressions are specified, any previously
JPA Doc
26

groupBy(grouping)

Method javax.persistence.criteria.AbstractQuery AbstractQuery groupBy(   List grouping ) Specify the expressions that are used to form groups over the query results. Replaces the previous specified grouping expressions, if any. If no grouping expressions are specified, any previously added
JPA Doc
26

groupBy(grouping)

grouping ) Specify the expressions that are used to form groups over the query results. Replaces the previous specified grouping expressions, if any. If no grouping expressions are specified, any previously added grouping expressions are simply removed. This method only overrides the return type
JPA Doc
26

groupBy(grouping)

Method javax.persistence.criteria.CriteriaQuery CriteriaQuery groupBy(   Expression... grouping ) Specify the expressions that are used to form groups over the query results. Replaces the previous specified grouping expressions, if any. If no grouping expressions are specified, any previously
JPA Doc
26

groupBy(grouping)

Method javax.persistence.criteria.CriteriaQuery CriteriaQuery groupBy(   List grouping ) Specify the expressions that are used to form groups over the query results. Replaces the previous specified grouping expressions, if any. If no grouping expressions are specified, any previously added
JPA Doc
26

groupBy(grouping)

Method javax.persistence.criteria.Subquery Subquery groupBy(   Listgrouping ) Specify the expressions that are used to form groups over the subquery results. Replaces the previous specified grouping expressions, if any. If no grouping expressions are specified, any previously