Oracle

Using the "ORDER BY" clause

Figo Kim 2006. 8. 28. 20:51
336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
  • Sort retrieved rows with the ORDER BY clause
    ASC : ascending order, default
    DESC : descending order
  • The ORDER BY clause comes last in the SELECT statement
SELECT last_name,job_id,department_id,hire_date
FROM employees
ORDER BY hire_date;


Syntax

SELECT expr
FROM table
[WHERE condition(s)]
[ORDER BY {column, expr, numeric_position} [ASC|DESC]};

'Oracle' 카테고리의 다른 글

Sorting  (0) 2006.08.28
Using the "ORDER BY" clause  (0) 2006.08.28
Logical Conditions  (0) 2006.08.27
Logical Conditions  (0) 2006.08.27
Comparison Conditions  (0) 2006.08.27