ํฌํจํ์ง ์๋ ๊ฒ
SELECT ANIMAL_ID,NAME FROM ANIMAL_INS WHERE INTAKE_CONDITION Not in ('Aged')
๋ค๋ฅธ ๋ฐฉ๋ฒ์ผ๋ก๋
SELECT ANIMAL_ID,NAME FROM ANIMAL_INS WHERE INTAKE_CONDITION <> 'Aged'
์ด๋ ๊ฒ๋
SELECT ANIMAL_ID,NAME FROM ANIMAL_INS WHERE INTAKE_CONDITION != 'Aged'
์ด๋ ๊ฒ๋ ํ ์ ์๋ค.
SELECT animal_id,name,datetime FROM animal_ins ORDER BY name ASC, datetime DESC
limit ์ด์ฉ
SELECT name FROM ANIMAL_INS ORDER BY datetime limit 1
๊ฐ์ฅ ์ต๊ทผ์ ์๊ฐ์ ๊ฐ์ ธ์๋ผ
SELECT max(datetime) FROM ANIMAL_INS
๋๋ฌผ์ ์ซ์ ์ธ๋ผ
SELECT count(*) FROM ANIMAL_INS
์ค๋ณต๋ ์ด๋ฆ ์ ๊ฑฐํ๊ณ , null์ด ์๋ ๋๋ฌผ ์ด๋ฆ์ ๊ฐฏ์?
SELECT COUNT(DISTINCT name) FROM ANIMAL_INS WHERE name is not null