SQL 고득점 Kit - SELECT/SUM,MIN,MAX/GROUP BY/IS NULL
·
코딩/MySql
1. SELECT SELECT * FROM ANIMAL_INS; 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 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 NAM..