【简答题】统计每个部门中人数( ) A.SELECT SUM(ID) FROM EMP GROUP BY DEPTNO; B.SELECT SUM(ID) FROM EMP ORDER BY DEPTNO; C.SELECT COUNT(ID) FROM EMP ORDER BY DEPTNO; D.SELECT COUNT(ID) FROM EMP GROUP BY DEPTNO;
【单选题】EXHIBIT, Emp Table Exhibit A Exhibit B Examine the data from the EMP table. Evaluate this SQL statement: SELECT * FROM emp WHERE emp _ id = 3); WHERE commission = (SELECT commission FROM emp What is t...
A.
Exhibit A
B.
Exhibit B
C.
The query returns no rows
D.
The query fails because the outer query is retrieving more than one column
E.
The query fails because both the inner and outer queries are retrieving data from the same table.