ObjectDB ObjectDB

Internal Website Search

1-10 of 160 resultsRefresh
106

GROUP BY and HAVING clauses

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

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
25

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
25

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
25

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
25

groupBy(grouping)

Method javax.persistence.criteria.Subquery<T> Subquery<T> groupBy( List<E> 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 grouping
25

groupBy(grouping)

Method javax.persistence.criteria.CriteriaQuery CriteriaQuery<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
25

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
25

groupBy(grouping)

Method javax.persistence.criteria.CriteriaQuery<T> CriteriaQuery<T> groupBy( List<E> 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
25

groupBy(grouping)

Method javax.persistence.criteria.AbstractQuery<T> AbstractQuery<T> groupBy( List<E> 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

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support