单选题
The EMPLOYEE table contains the following information: EMPNO NAME WORKDEPT 101 SAM A11 102 JOHN C12 103 JANE -104 PAT Remote 105 ANNE -106 BOB A11 The MANAGER table contains the following information: MGRID NAME DEPTNO EMPCOUNT 1 WU B01 - 2 JONES A11 - 3 CHEN - - 4 SMITH - -5 THOMAS C12 - After this statement is executed: UPDATE manager m SET empcount = (SELECT COUNT(workdept) FROM employee e WHERE workdept=m.deptno) What is the result of the following query?（） SELECT mgrid, empcount FROM MANAGER WHERE empcount IS NOT NULL ORDER BY mgrid
发布日期：2022-06-21
A
MGRID EMPCOUNT ----- -------- 1 0 2 2 5 1
B
MGRID EMPCOUNT ----- -------- 1 0 2 2 3 0 4 0 5 1
C
MGRID EMPCOUNT ----- -------- 1 3 2 3 3 3 4 3 5 3
D
MGRID EMPCOUNT ----- -------- 1 0 2 2 3 2 4 2 5 1
标签： "暂无标签"
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在