ObjectDB ObjectDB

Internal Website Search

1-10 of 15 resultsRefresh
89

GROUP BY and HAVING clauses

"))); q.groupBy(c.get("currency")); g.having(cb.gt(cb.count(c), 1)); The CriteriaBuilder ... , greatest - return an expression representing the maximum of comparable values. The groupBy method ... of expressions in another form of groupBy). Setting a HAVING clause is very similar to setting a WHERE clause
81

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
81

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
81

groupBy(grouping)

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

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
81

groupBy(grouping)

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

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
81

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
81

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
81

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

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