About GROUP BY

21-30 of 200Refresh
JPA Doc
31

groupBy(grouping)

Method javax.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, any previously added
JPA Doc
31

groupBy(grouping)

Method javax.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 previously added
JDO Doc
29

addFetchGroups(groups)

Method javax.jdo.PersistenceManagerFactory void addFetchGroups(   FetchGroup... groups ) Add the FetchGroups to the set of active fetch groups. FetchGroups are made unmodifiable before being added ... : groups - an array of FetchGroups Throws: SecurityException - if the caller is not authorized for JDOPermission ("manageMetadata") Since: JDO 2.2
JDO Doc
29

removeFetchGroups(groups)

Method javax.jdo.PersistenceManagerFactory void removeFetchGroups(   FetchGroup... groups ) Remove the FetchGroups from the set of active FetchGroups. Existing FetchGroups that match parameter ... . Parameters: groups - an array of FetchGroups Throws: SecurityException - if the caller is not
JPA Doc
27

javax.persistence.criteria.CriteriaQuery

to the given entity Since: JPA 2.0 List> getGroupList() Return a list of the grouping expressions. Return a list of the grouping expressions. Returns empty list if no grouping expressions have been specified. Modifications to the list do not affect the query. Returns: the list of grouping
Manual
27

CRUD Database Operations with JPA

the results (using an ORDER BY clause) and even group results (using GROUP BY and HAVING clauses). JPQL ... a managed entity) by the persist method. The new Point objects are physically stored in the database ... objects in the database by using a simple query: Query q1 = em.createQuery("SELECT COUNT(p) FROM
Manual
23

FROM clause (JPQL / Criteria API)

at the WHERE clause level by using a type expression. For example, in the following query, c iterates ... , and the same query can also be written as follows: SELECT c FROM Country c By default, the name ... name). The default name can be overridden by specifying another name explicitly in the @Entity's
Manual
23

Comparison in JPQL and Criteria API

operators. JPQL follows the SQL notation, where Java uses its own notation (which is also in use by JDOQL ... , there is also a difference in the way that NULL values are handled by these operators. Comparing NULL values The following table shows how NULL values are handled by each comparison operator. One column presents
Tutorial
23

Getting Started with JPA

to start by running a live sample application in your IDE, you should be able to follow this tutorial
JDO Doc
22

javax.jdo.JDOEntityManager

to the type specified by the resultClass argument. Parameters: name - the name of a query defined in ... item, which must be assignable to the type specified by the resultClass argument. Parameters: qlString ... or is managed by another PersistenceManager. Parameters: pc - a persistent instance Since: JDO 1.0