Home » Search

About GROUP BY

21-30 of 200Refresh
JPA Doc
25

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
25

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
23

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
23

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
21

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
21

CRUD Database Operations with JPA

(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 Point
Manual
18

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
18

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
JPA Doc
17

Criteria Query Selection and Results

The JPA Criteria API interfaces in this group are in use for setting the SELECT and ORDER BY ... clause in a criteria query is represented by Selection: Because Selection is a super interface ... expressions can be represented by CompoundSelection, which is itself a subinterface of Selection
JPA Doc
17

JPA Queries

three groups. SELECT and ORDER BY elements (including tuples): FROM clause elements (representing range ... Queries are represented in JPA by the Query and TypedQuery interfaces: The JPA Query API section ... only at runtime (e.g. depending on which fields are filled by a user in a form) can be done by