Oracle
1Z0-007 · Question #130
Exhibit Evaluate this SQL statement: SELECT cust_id, ord_total FROM orders WHERE ord_total > ANY (SELECT ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE city LIKE `New…
The correct answer is A. Option A. See the full explanation below for the reasoning.
Question
Exhibit Evaluate this SQL statement:
SELECT cust_id, ord_total FROM orders WHERE ord_total > ANY (SELECT ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE city LIKE `New York')); What is the result when the above query is executed?
Exhibits
Options
- AOption A
- BOption B
- COption C
- DOption D
- EOption E
- FOption F
How the community answered
(53 responses)- A77% (41)
- C8% (4)
- D11% (6)
- E2% (1)
- F2% (1)
Community Discussion
No community discussion yet for this question.