-
MySQL/Oracle -- 코드를 입력하세요 SELECT ANIMAL_ID, NAME FROM ANIMAL_INS WHERE INTAKE_CONDITION NOT IN ('Aged') ORDER BY ANIMAL_ID;
MySQL/Oracle SELECT ANIMAL_ID, NAME FROM ANIMAL_INS ORDER BY ANIMAL_ID;
MySQL/Oracle -- 코드를 입력하세요 SELECT ANIMAL_ID, NAME, DATETIME FROM ANIMAL_INS ORDER BY NAME ASC, DATETIME DESC;
MySQL SELECT NAME FROM ANIMAL_INS ORDER BY DATETIME LIMIT 1; Oracle SELECT NAME FROM (SELECT * FROM ANIMAL_INS ORDER BY DATETIME) WHERE ROWNUM = 1;
MySQL SELECT COUNT(*) USERS FROM USER_INFO WHERE AGE >= 20 AND AGE = 20 AND AGE