inblog logo
|
silver
    SQL문제풀기

    [SQL문제다시풀기] 어린 동물 찾기 - where not

    silver's avatar
    silver
    Feb 09, 2025
    [SQL문제다시풀기] 어린 동물 찾기 - where not
    Contents
    문제MYSQLORACLE

    문제

    school.programmers.co.kr
    https://school.programmers.co.kr/learn/courses/30/lessons/59037?language=mysql

    MYSQL

    내가 작성한 정답

    SELECT animal_id, name from animal_ins where not intake_condition ='Aged' order by 1

    ORACLE

    내가 작성한 정답

    SELECT ANIMAL_ID, NAME FROM ANIMAL_INS WHERE NOT INTAKE_CONDITION = 'Aged' ORDER BY ANIMAL_ID ASC;
     
    💡
    where에서 아닌 조건
    where not + 컬럼 조건!
    Share article

    silver

    RSS·Powered by Inblog