ORDER BY

sort(정렬)
1) 기준(key)
2) 차순(오름차순, 내림차순)

 

SELECT first_name 이름, salary 급여
FROM employees
ORDER BY salary ASC; --asc 생략 가능

SELECT first_name 이름, salary 급여, employee_id id
FROM employees
WHERE employee_id<=110
ORDER BY salary DESC;

--칼럼명으로 정렬
SELECT first_name 이름, salary 급여, employee_id id
FROM employees
ORDER BY salary DESC, employee_id;
--별명으로 정렬
SELECT first_name 이름, salary 급여, employee_id id
FROM employees
ORDER BY 급여 DESC, id;
--순번으로 정렬
SELECT first_name 이름, salary 급여, employee_id id
FROM employees
ORDER BY 2 DESC, 3;
--order by에 계산식 쓰기
SELECT first_name 이름, salary 급여, employee_id id, salary*12 연봉
FROM employees
ORDER BY 급여*12 DESC, 3;