슈뢰딩거의 고등어

SQL 기입 순서 select >> from >> where >> group by >> having >> order by >> limit 중복제거 select count(distinct name) from animal_ins where name != 'NULL'; case 사용법 select animal_type, case when name is not null then name else 'No name' end as name, sex_upon_intake from animal_ins; date_format() select animal_id, name, date_format(datetime, '%Y-%m-%d') from animal_ins; having select name, count(name) fr..