About SELECT

11-20 of 200Refresh
JPA Doc
68

construct(resultClass, selections)

> resultClass,   Selection[] selections ) Create a selection item corresponding to a constructor ... after the query is executed. Parameters: resultClass - class whose instance is to be constructed selections - arguments to the constructor Returns: compound selection item Throws: IllegalArgumentException
JPA Doc
68

construct(resultClass, selections)

> resultClass,   Selection... selections ) Create a selection item corresponding to a constructor ... after the query is executed. Parameters: resultClass - class whose instance is to be constructed selections - arguments to the constructor Returns: compound selection item Throws: IllegalArgumentException
JPA Doc
68

isCompoundSelection()

Method javax.persistence.criteria.Selection boolean isCompoundSelection() Whether the selection item is a compound selection. Returns: boolean indicating whether the selection is a compound selection Since: JPA 2.0
JPA Doc
68

alias(name)

Method javax.persistence.criteria.Selection Selection alias(   String name ) Assigns an alias to the selection item. Once assigned, an alias cannot be changed or reassigned. Returns the same selection item. Parameters: name - alias Returns: selection item Since: JPA 2.0
Manual
65

Chapter 4 - JPA Queries (JPQL / Criteria)

(and a criteria query) is explained by describing the main clauses of JPQL queries (SELECT, FROM, WHERE, GROUP
JPA Doc
65

select(expression)

Method javax.persistence.criteria.Subquery Subquery select(   Expression expression ) Specify the item that is to be returned as the subquery result. Replaces the previously specified selection, if any. Parameters: expression - expression specifying the item that is to be returned as
JPA Doc
61

SharedCacheMode.DISABLE_SELECTIVE

JavaDoc Reference Documentation - Caching is enabled for all entities except those for which Cacheable(false) is specified.
JPA Doc
61

SharedCacheMode.ENABLE_SELECTIVE

JavaDoc Reference Documentation - Caching is enabled for all entities for Cacheable(true) is specified.
Manual
37

GROUP BY and HAVING clauses

clause in the query execution order is after the FROM and WHERE clauses, but before the SELECT ... to grouping by the GROUP BY clauses before arriving at the SELECT clause. GROUP BY as DISTINCT (no Aggregates) The following query groups all the countries by their first letter: SELECT SUBSTRING(c
Manual
36

Database Explorer

Embedded... command and select a local database file. To open a database in client-server mode select File > Open C/S Connection... and provide host, port, username and password for a client-server ... the tree). To open a new viewer window either write a query in the [Query] tabbed window or select