300 | ORDER BY clause (JPQL / Criteria API)The ORDER BY clause specifies a required order for the query results. Any JPQL query that does not include an ORDER BY clause produces results in an undefined and non-deterministic order. ORDER BY ... is at least one million people, ordered by the country name: SELECT c.name FROM Country c WHERE c.population > 1000000 |
75 | javax.persistence.criteria.Orderjavax.persistence.criteria Interface Order An object that defines an ordering over the query results. Since: JPA 2.0 Learn how to use JPA Criteria API's Order in Chapter 4 of the ObjectDB/JPA manual. Expression getExpression() Return the expression that is used for ordering. Return |
75 | javax.jdo.annotations.Orderjavax.jdo.annotations Annotation Order Target: Fields (including property get methods) Annotation for the ordering component of an ordered container member, such as Java Collections Framework Array and List types and Java native array types. Corresponds to the xml element "order". Since: JDO 2.1 |
74 | setOrdering(ordering)Method javax.jdo.Query void setOrdering( String ordering ) Set the ordering specification for the result Collection. The ordering specification is a String containing one or more ordering declarations separated by commas. Each ordering declaration is the name of the field on which to order |
72 | reverse()Method javax.persistence.criteria.Order Order reverse() Switch the ordering. Returns: a new Order instance with the reversed ordering Since: JPA 2.0 |
71 | isAscending()Method javax.persistence.criteria.Order boolean isAscending() Whether ascending ordering is in effect. Returns: boolean indicating whether ordering is ascending Since: JPA 2.0 |
71 | getExpression()Method javax.persistence.criteria.Order Expression getExpression() Return the expression that is used for ordering. Returns: expression used for ordering Since: JPA 2.0 |
71 | Order.columnsAnnotation Element javax.jdo.annotations.Order Column[] columns The definition of the column(s) to use for ordering. Returns: the columns to use for ordering Default value: {} Since: JDO 2.1 |
71 | Order.columnAnnotation Element javax.jdo.annotations.Order String column The name of the column to use for ordering the elements of the member. Returns: the name of the ordering column Default value: "" Since: JDO 2.1 |
71 | Order.mappedByAnnotation Element javax.jdo.annotations.Order String mappedBy Name of a field or property in the target class that acts as the ordering field or property for this member. Return the name of the field or property in the target class Default value: "" Since: JDO 2.1 |
