ORDER BY clause

The ORDER BY clause specifies an ordering of the objects in the result collection

ORDER BY  [ order_element ,]* order_element
order_element ::= { path-expression | integer } [ ASC | DESC ]

The path expression must specify a single valued field that is a primitive type of byte, short, int, long, float, double, char or a wrapper type of Byte, Short, Integer, Long, Float, Double, BigDecimal, String, Character, java.util.Calendar, java.util.Date, java.sql.Date, java.sql.Time, java.sql.Timestamp.

ASC specifies ascending order and is the default. DESC specifies descending order.

Integer refers to a selection expression in the SELECT clause.

 

Example: ORDER BY clause

Return department objects

in decreasing deptno order

SELECT  OBJECT(d) FROM  DeptBean d ORDER BY  d.deptno DESC

Return employee objects sorted by department number and name

SELECT  OBJECT(e) FROM EmpBean e ORDER BY e.dept.deptno ASC,  e.name DESC

The following is a valid dynamic query

SELECT OBJECT(e), e.salary+e.bonus as total_pay FROM  EmpBean e ORDER BY  2 DESC

---

 

See Also

EJB query language

 

Related Tasks

Using EJB query
Using the dynamic query service

 

---