About SELECT

manual

SELECT clause (JPQL / Criteria API)

Explains how to use the SELECT clause and projections in a JPA/JPQL query.... See JavaDoc Reference Page... ( "SELECT c FROM Country c" , Country. class ) ; ... getResultList() TypedQuery's method Execute a SELECT query and return the query results as a typed List. See JavaDoc ... the ability to use almost any valid JPQL expression in SELECT clauses. Specifying the required query results more precisely can ...

 
api-jpa

javax.persistence.criteria.Selection

The Selection interface defines an item that is to be returned in a query result.(Interface of JPA)

 
api-jpa

Criteria Query Selection and Results

Reference (JavaDoc) of JPA query criteria result interfaces, including Selection, CompoundSelection, Order and Tuple.... API interfaces in this group are in use for setting the SELECT and ORDER BY clauses and for representing query results as tuples. SELECT Clause Elements The content of the SELECT clause in a criteria ...

 
api-jpa

select(selection)

Specify the item that is to be returned in the query result.(Method of javax.persistence.criteria.CriteriaQuery)

 
manual

JPA Query Structure (JPQL / Criteria)

Explains the structure of a JPQL query, which consists of 6 clauses: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.... JPQL Query Structure As with SQL, a JPQL SELECT query also consists of up to 6 clauses in the following format: SELECT ... FROM ... [ WHERE ... ] [ ...

 
api-jpa

multiselect(selections)

Specify the selection items that are to be returned in the query result.(Method of javax.persistence.criteria.CriteriaQuery)

 
api-jpa

array(selections)

Create an array-valued selection item.(Method of javax.persistence.criteria.CriteriaBuilder)

 
api-jpa

construct(resultClass, selections)

Create a selection item corresponding to a constructor.(Method of javax.persistence.criteria.CriteriaBuilder)

 
manual

JPA Criteria API Queries

Explains how to use the JPA Criteria API (CriteriaBuilder, CriteriaQuery, etc.) to build JPQL like queries.... string represents a minimal JPQL query: SELECT c FROM Country c An equivalent query can be built using ... ( Country. class ) ; q. select select(selection) CriteriaQuery's method Specify the ...

 
api-jpa

tuple(selections)

Create a tuple-valued selection item.(Method of javax.persistence.criteria.CriteriaBuilder)