About GROUP BY

11-20 of 200Refresh
Forum
24

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
24

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
24

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
24

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
24

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
24

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
24

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
24

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
24

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

groupBy(grouping)

Method javax.persistence.criteria.Subquery Subquery groupBy(   Expression... grouping ) 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 added