[SQL] SELECT문 ORDER BY 정리

1. 오름차순 정렬하기

SELECT *
from ANIMAL_INS
order by ANIMAL_ID;

SELECT ANIMAL_ID, NAME
FROM ANIMAL_INS 
ORDER BY ANIMAL_ID ASC;

 

2. 내림차순 정렬하기

SELECT NAME, DATETIME
from ANIMAL_INS
order by ANIMAL_ID DESC;

 

3. 다중 기준 정렬하기

SELECT ANIMAL_ID, NAME, DATETIME
FROM ANIMAL_INS 
ORDER BY NAME ASC, DATETIME DESC;

 

4. 조건 걸기

SELECT ANIMAL_ID, NAME
from ANIMAL_INS
where INTAKE_CONDITION = "Sick";

SELECT ANIMAL_ID, NAME
FROM ANIMAL_INS
WHERE INTAKE_CONDITION != "Aged";

 

5. 최상위 하나만 출력하기

SELECT NAME 
FROM ANIMAL_INS 
WHERE DATETIME = (SELECT Min(DATETIME) FROM ANIMAL_INS)