SQLD(SQL 개발자) 기출 · DML

이 문제 풀어보기

1. 1.UPDATE EMP
   SET BONUS = (SELECT MAX(AMOUNT)
   FROM BONUS_LOG B
   WHERE EMP.EMP_ID = B.EMP_ID
   AND B.YEAR = 2024);
2. 2.UPDATE EMP
   SET BONUS = (SELECT MAX(0)
   FROM BONUS_LOG B
   WHERE EMP.EMP_ID = B.EMP_ID
   AND B.YEAR = 2024);
3. 3.UPDATE EMP
   SET BONUS = (SELECT COALESCE(MAX(NULL), 0)
   FROM BONUS_LOG B
   WHERE EMP.EMP_ID = B.EMP_ID);
4. 4.UPDATE EMP
   SET BONUS = NULL;