389 | GROUP BY and HAVING clausesThe GROUP BY clause enables grouping of query results. A JPQL query with a GROUP BY clause returns properties of generated groups instead of individual objects and fields. The position of a GROUP BY ... clause. When a GROUP BY clause exists in a JPQL query, database objects (or tuples of database objects |
163 | Grouping by date() have to group by date(). For few queries I was concatenating 'date' from year()-month()-day() calls ... . When you group by date() there are two days per day. I mean group by divides each day ... hour(ov.created), count(ov) from ObjectView ov group by hour(ov.created) order by hour(ov.created) ASC |
161 | Group by date / timeHi, 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 |
160 | ORDER BY clause (JPQL / Criteria API): SELECT c.name FROM Country c ORDER BY c.name DESC Grouping (GROUP BY) Order The ORDER BY clause ... and a GROUP BY clause the SELECT clause receives groups rather than individual objects and ORDER BY ... WHERE 'Europe' MEMBER OF c.continents GROUP BY c.currency HAVING COUNT(c) > 1 ORDER BY c.currency The ORDER |
156 | Group by: list if no aggregate function is specifiedHello! 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 |
30 | groupBy(grouping)Method javax.persistence.criteria.Subquery Subquery<T> 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 |
30 | groupBy(grouping)Method javax.persistence.criteria.Subquery Subquery<T> groupBy( List<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 |
30 | groupBy(grouping)Method javax.persistence.criteria.AbstractQuery AbstractQuery<T> 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 |
6 | setGrouping(group)Method javax.jdo.Query void setGrouping( String group ) Set the grouping expressions, optionally including a "having" clause. When grouping is specified, each result expression must either be an expression contained in the grouping, or an aggregate evaluated once per group. Parameters: group |
4 | [ODB1] Chapter 4 - JDO Metadata fetch group should include fields that are needed often and are relatively small. By default ... , arrays and references to user defined classes are excluded by default. The default-fetch-group attribute ... . The metadata is used first by the JDO Enhancer, and later by the JDO |
