[Database] 10. Order By

-- 정렬 (오름차순)
select *
from emp
where deptno = 20
order by sal asc;

-- 정렬 (내림차순)
select *
from emp
where deptno = 20
order by sal desc;

-- 둘 다 써보기 (순서 중요)
select *
from emp
where deptno = 20
order by  ename asc, sal desc;