less than 1 minute read

2. 역순 정렬하기

SELECT NAME, DATETIME FROM ANIMAL_INS ORDER BY ANIMAL_ID DESC;

3. 아픈 동물 찾기

SELECT ANIMAL_ID, NAME FROM ANIMAL_INS WHERE INTAKE_CONDITION='Sick' ORDER BY ANIMAL_ID;

4. 어린 동물 찾기

SELECT ANIMAL_ID, NAME FROM ANIMAL_INS WHERE NOT INTAKE_CONDITION='Aged' ORDER BY ANIMAL_ID;

5. 동물의 아이디와 이름

SELECT ANIMAL_ID, NAME FROM ANIMAL_INS ORDER BY ANIMAL_ID

6. 여러 기준으로 정렬하기

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

7. 상위 N개 레코드

SELECT NAME FROM ANIMAL_INS ORDER BY DATETIME LIMIT 1;

8.

# SELECT DATETIME FROM ANIMAL_INS ORDER BY DATETIME DESC LIMIT 1;
SELECT MAX(DATETIME) FROM ANIMAL_INS
SELECT MIN(DATETIME) as 시간 FROM ANIMAL_INS;
SELECT COUNT(*) as count FROM ANIMAL_INS;
SELECT COUNT(DISTINCT(NAME)) AS count FROM ANIMAL_INS;

Updated: