Oracle
1Z0-007 · Question #131
Examine the data from the EMP table. Evaluate this SQL statement: SELECT * FROM emp WHERE commission = (SELECT commission FROM emp WHERE emp_id=3); What is the result when the query is executed?
The correct answer is C. The query returns no rows. See the full explanation below for the reasoning.
Question
Examine the data from the EMP table. Evaluate this SQL statement:
SELECT * FROM emp WHERE commission = (SELECT commission FROM emp WHERE emp_id=3); What is the result when the query is executed?
Options
- AExhibit A
- BExhibit B
- CThe query returns no rows
- DThe query fails because the outer query is retrieving more than one column
- EThe query fails because both the inner and outer queries are retrieving data from the same table.
How the community answered
(50 responses)- A4% (2)
- B2% (1)
- C70% (35)
- D8% (4)
- E16% (8)
Community Discussion
No community discussion yet for this question.