yongwmin95

<p style="box-sizing: border-box; margin: 0px 0px 12px; padding: 0px; line-height: 1.5; font-size: 16px; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji'; background-color: #ffffff;">set&nbsp;
<p style="box-sizing: border-box; margin: 0px 0px 12px; padding: 0px; line-height: 1.5; font-size: 16px; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji'; background-color: #ffffff;">job=(select job
<p style="box-sizing: border-box; margin: 0px 0px 12px; padding: 0px; line-height: 1.5; font-size: 16px; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji'; background-color: #ffffff;">from emp01
<p style="box-sizing: border-box; margin: 0px 0px 12px; padding: 0px; line-height: 1.5; font-size: 16px; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji'; background-color: #ffffff;">where deptno=20 and sal=(select max(sal)
<p style="box-sizing: border-box; margin: 0px 0px 12px; padding: 0px; line-height: 1.5; font-size: 16px; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji'; background-color: #ffffff;">from emp01
<p style="box-sizing: border-box; margin: 0px 0px 12px; padding: 0px; line-height: 1.5; font-size: 16px; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji'; background-color: #ffffff;">where deptno=20)),
<p style="box-sizing: border-box; margin: 0px 0px 12px; padding: 0px; line-height: 1.5; font-size: 16px; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji'; background-color: #ffffff;">이 부분에서 결과가 2개가 나타나는데
<p style="box-sizing: border-box; margin: 0px 0px 12px; padding: 0px; line-height: 1.5; font-size: 16px; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji'; background-color: #ffffff;">아직도 해결방법을 잘 모르겠습니다... 강좌를 다시 보면서 수정도 여러번 해봤는데요.. 혹시 풀이를 알려주실 수 있을까요??
<p style="box-sizing: border-box; margin: 0px 0px 12px; padding: 0px; line-height: 1.5; font-size: 16px; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji'; background-color: #ffffff;">여러번 질문드려서 죄송합니다 ㅜㅜ
<p style="box-sizing: border-box; margin: 0px 0px 12px; padding: 0px; line-height: 1.5; font-size: 16px; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji'; background-color: #ffffff;">
<p style="box-sizing: border-box; margin: 0px 0px 12px; padding: 0px; line-height: 1.5; font-size: 16px; color: #24292e; font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji'; background-color: #ffffff;">

마지막 문제 질문있습니다

update emp01
set&nbsp;
job=(select job
from emp01
where deptno=20 and sal=(select max(sal)
from emp01
where deptno=20)),
sal =(select max(sal)
from emp01
where deptno=20)
where job = 'CLERK';
이렇게 했을 때&nbsp;
단일 행 하위 질의에 2개 이상의 행이 리턴되었습니다.
라고 오류가 나오는데요.
어떻게 해야하는지 궁금합니다

건너뛰고 4강도 보는데 10분30초 정도부터 안맞네요

yongwmin95

Posts