ObjectDB Database Search
1-12 of 12 resultsGROUP BY and HAVING clauses. where (cb. isMember ("Europe", c. get ("continents"))); q. groupBy (c. get ("currency")); g. having (cb ... ;expression representing the maximum of comparable values. The groupBy method takes ... another form of groupBy ). Setting a HAVING clause is very similar to setting a WHERE clause . As | |
CriteriaQuery.groupBy(grouping) - JPA Method JPA Method in jakarta.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 | |
CriteriaQuery.groupBy(grouping) - JPA Method JPA Method in jakarta.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 | |
Subquery.groupBy(grouping) - JPA Method JPA Method in jakarta.persistence.criteria.Subquery Subquery groupBy ( List 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 | |
AbstractQuery | |
AbstractQuery | |
Subquery.groupBy(grouping) - JPA Method JPA Method in jakarta.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 | |
JPA Query Structure (JPQL / Criteria);( where ). Criteria GROUP BY / HAVING ( groupBy , having , count , sum , avg , min , max | |
JPA Criteria API Queries ( where ). GROUP BY / HAVING clauses ( groupBy , having , count , sum , avg , min , max , ...). ORDER BY | |
InterfaceRef jakarta.persistence.criteria.AbstractQuery AbstractQuery groupBy ( Expression ... grouping) Specify the expressions that are used to form ... AbstractQuery groupBy (List grouping) Specify the expressions that are used to form groups | |
InterfaceRef jakarta.persistence.criteria.Subquery Subquery groupBy ( Expression ... grouping) Specify the expressions that are used to form groups ... - zero or more grouping expressions Return: the modified subquery Since: JPA 2.0 Subquery groupBy | |
InterfaceRef jakarta.persistence.criteria.CriteriaQuery groupBy ( Expression ... grouping) Specify the expressions that are used to form groups ... more grouping expressions Return: the modified query Since: JPA 2.0 CriteriaQuery groupBy (List   |