ObjectDB Database Search

1-12 of 12 results

GROUP 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.groupBy(grouping) - JPA Method

JPA Method in jakarta.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

AbstractQuery.groupBy(grouping) - JPA Method

JPA Method in jakarta.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

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