haju__log

SELECT ANIMAL_IDFROM ANIMAL_INSWHERE NAME IS NULLORDER BY ANIMAL_ID ASC;

SELECT ANIMAL_IDFROM ANIMAL_INSWHERE NAME IS NOT NULLORDER BY ANIMAL_ID ASC;

SELECT WAREHOUSE_ID,WAREHOUSE_NAME,ADDRESS,CASE WHEN FREEZER_YN IS NULL THEN 'N' WHEN FREEZER_YN='N' THEN 'N'ELSE 'Y'END AS "FREEZER_YN"FROM FOOD_WAREHOUSEWHERE ADDRESS LIKE "경기도%"ORDER BY WAREHOUSE_ID ASC; ✅ CASE 문 : 조건에 따라 값 지정하기SELECT 컬럼명,컬럼명, CASE WHEN(조건A) THEN A WHEN(조건B) THEN B ELSE CEND AS "원하는 컬럼명"FROM TABLE_NAME;CASE, WHEN, THEN, ELSE, END 사용CASE : CASE 문을 시작하겠다고 알림WH..

SELECT SUM(PRICE) AS "TOTAL_PRICE"FROM ITEM_INFOWHERE RARITY='LEGEND';