Home » Search

About SELECT

11-20 of 200Refresh
JPA Doc
61

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
61

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
61

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

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
59

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
Manual
51

Chapter 4 - JPA Queries (JPQL / Criteria)

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

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
30

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
Manual
30

FROM clause (JPQL / Criteria API)

over all the Country objects in the database: SELECT c FROM Country AS c The AS keyword is optional, and the same query can also be written as follows: SELECT c FROM Country c By default, the name ... returns all the pairs of countries that share a common border: SELECT c1, c2 FROM Country c1, Country c2
Manual
30

ORDER BY clause (JPQL / Criteria API)

is at least one million people, ordered by the country name: SELECT c.name FROM Country c WHERE c.population > 1000000 ... clause produces objects for examination and the WHERE clause selects which objects to collect as results. Then the SELECT clause builds the results by evaluating the result expressions. Finally the results