정렬 : ORDER BY

ORDER BY 정렬

오름차순 ASC 1,2,3,4,5
내림차순 DESC 5,4,3,2,1
               

오름차순은 ASC를 생략가능하다

 

월급에 따라 오름차순으로 정렬

select * from employee
order by salary asc;

내림차순으로 정렬

select * from employee
order by salary desc;

salary 내림차순으로 정렬하되 값이 같을 경우 ename을 오름차순으로 정렬

select * from employee
order by salary desc, ename asc;