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 |