개발 공부하는 빙빙

SELECT ANIMAL_ID,NAME,SEX_UPON_INTAKE FROM ANIMAL_INS WHERE NAME IN ('Lucy', 'Ella', 'Pickle', 'Rogan', 'Sabrina', 'Mitty') ORDER BY ANIMAL_ID; Where조건절에서 IN을 사용하여 괄호 안에 있는 문자열들이 있는 NAME만을 조건으로 줬다.

SELECT ANIMAL_TYPE,IFNULL(NAME,"No name") AS NAME ,SEX_UPON_INTAKE FROM ANIMAL_INS ORDER BY ANIMAL_ID; select절에 ifnull(컬럼,"값")으로 해줘서, 컬럼이 null인걸 값으로 대체시켜준다.

SELECT ANIMAL_ID FROM ANIMAL_INS WHERE NAME IS NOT NULL;

SELECT ANIMAL_ID FROM ANIMAL_INS WHERE NAME IS NULL;

SELECT NAME FROM ANIMAL_INS ORDER BY DATETIME LIMIT 1;

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

SELECT ANIMAL_ID,NAME FROM ANIMAL_INS ORDER BY ANIMAL_ID;

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

SELECT ANIMAL_ID, NAME FROM ANIMAL_INS WHERE INTAKE_CONDITION = 'SICK';

SELECT NAME, DATETIME FROM ANIMAL_INS ORDER BY ANIMAL_ID DESC;