The EMPLOYEE table contains the

单项选择题 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: 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

热门试题