单选题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.