본문 바로가기
💻 하나씩 차곡차곡/프로그래머스 (SQL)

[IS NULL/LEVEL1] 경기도에 위치한 식품창고 목록 출력하기 (MySQL/Oracle)

by 뚜루리 2023. 4. 8.
728x90
320x100

MySQL

SELECT    WAREHOUSE_ID
        , WAREHOUSE_NAME
        , ADDRESS
        , IFNULL(FREEZER_YN, 'N') AS FREEZER_YN
FROM FOOD_WAREHOUSE
WHERE WAREHOUSE_NAME LIKE '%경기%'
ORDER BY WAREHOUSE_ID

 


Oracle

SELECT    WAREHOUSE_ID
        , WAREHOUSE_NAME
        , ADDRESS
        , NVL(FREEZER_YN, 'N') AS FREEZER_YN
FROM FOOD_WAREHOUSE
WHERE ADDRESS LIKE '%경기도%'
ORDER BY WAREHOUSE_ID;
728x90
320x100