💻 하나씩 차곡차곡/프로그래머스 (SQL)
[IS NULL/LEVEL1] 경기도에 위치한 식품창고 목록 출력하기 (MySQL/Oracle)
뚜루리
2023. 4. 8. 07:12
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