117 | Method javax.persistence.criteria.CriteriaBuilder Order desc( Expression<?> x ) Create an ordering by the descending value of the expression. Parameters: x - expression used to define the ordering Returns: descending ordering corresponding to the expression Since: JPA 2.0 |
52 | successfully] 04> SELECT u FROM Goods u where u._code like :code AND u._desc like :desc 05> code= %, desc= % 06> UI: end query 07> UI: start printing result 08> code= A, desc= Good A, byUser= test 09> code= B, desc= Good B, byUser= test 10> code= C, desc= Good C, byUser= test 11> UI: end printing result |
51 | variables that are defined in the FROM clause. Order Direction (ASC, DESC) The default ordering direction ... On the other hand, to apply descending order the DESC keyword must be added explicitly to the order expression: SELECT c.name FROM Country c ORDER BY c.name DESC Grouping (GROUP BY) Order The ORDER BY clause |
27 | around Expression, which adds order direction - either ascending (ASC) or descending (DESC). The CriteriaBuilder's asc and desc methods take an expression and return an ascending or descending Order |
19 | ,DELETE, DESC, DISTINCT, ELSE, EMPTY, END, ENTRY, ESCAPE, EXISTS, FALSE, FETCH,FROM, GROUP, HAVING, IN |
19 | GROUP BY / HAVING (groupBy, having, count, sum, avg, min, max, ...). Criteria ORDER BY (orderBy, Order, asc, desc). |
19 | expressions). GROUP BY (including HAVING and aggregates). ORDER BY (including ASC, DESC). Aggregates |
19 | , count, sum, avg, min, max, ...). ORDER BY clause (orderBy, Order, asc, desc). The links |
11 | _field_name] [ASC | DESC] If ASC or DESC is not specified, ASC (ascending order) is assumed ... _item [,orderby_item]* orderby_item::= [property_or_field_name] [ASC | DESC] If ASC or DESC |
8 | , the default values apply. Example 1: @Column(name="DESC", nullable=false, length=512) public String getDescription() { return description; } Example 2: @Column(name="DESC |