Home » Search

About GROUP BY

11-20 of 200Refresh
Manual
26

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

Group by date / time

Hi, I'm trying to create reporting query that will return entities grouped by year / mont / day ... stats WHERE YEAR(record_date) = 2009 GROUP BY YEAR(record_date), MONTH(record_date) or maybe something like this: SELECT COUNT(id) FROM stats WHERE YEAR(record_date) = 2009 GROUP BY DATE
Forum
25

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