9] 프로그래머스 루시와 엘라 찾기

 

SELECT ANIMAL_ID, NAME, SEX_UPON_INTAKE
FROM ANIMAL_INS 
WHERE NAME IN('Lucy', 'Ella', 'Pickle', 'Rogan', 'Sabrina', 'Mitty')
-- WHERE NAME = "Lucy" or NAME ="Ella" or NAME = "Pickle" or NAME = "Rogan" or NAME = "Sabrina" or NAME = "Mitty"
ORDER BY ANIMAL_ID;

www.dofactory.com/sql/where-in

SQL WHERE IN, SELECT WHERE IN List or Subquery - with Examples - Dofactory