单选题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 the result when the query is executed?()AExhibit A

题目
单选题
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 the result when the query is executed?()
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.


相似考题