SELECT * FROM ANIMAL_INS ORDER BY ANIMAL_ID;
SELECT NAME, DATETIME FROM ANIMAL_INS ORDER BY ANIMAL_ID DESC;
SELECT ANIMAL_ID, NAME FROM ANIMAL_INS WHERE INTAKE_CONDITION = 'Sick';
SELECT ANIMAL_ID, NAME FROM ANIMAL_INS WHERE NOT INTAKE_CONDITION = 'Aged';
SELECT ANIMAL_ID, NAME FROM ANIMAL_INS ORDER BY ANIMAL_ID;
SELECT ANIMAL_ID, NAME, DATETIME FROM ANIMAL_INS ORDER BY NAME, DATETIME DESC;
SELECT NAME FROM ANIMAL_INS WHERE DATETIME = (SELECT MIN(DATETIME) FROM ANIMAL_INS);
'Programming > SQL' 카테고리의 다른 글
[MYSQL] Data INSERT, UPDATE, DELETE (0) | 2021.02.25 |
---|---|
[MYSQL] 우유와 요거트가 담긴 장바구니 (0) | 2021.02.16 |
[MYSQL] SELECT is null FROM Programmers (0) | 2021.02.06 |
[MYSQL] SELECT groupby FROM Programmers (0) | 2021.01.31 |
[MYSQL] SELECT sum,max,min FROM Programmers (0) | 2020.12.30 |
[MYSQL] SELECT select FROM Programmers (0) | 2020.12.26 |