Which of the following is a valid SELECT statement? a. SELECT order# FROM orders WHERE shipdate =

Question:

Which of the following is a valid SELECT statement?
a. SELECT order# FROM orders

WHERE shipdate = SELECT shipdate FROM orders
WHERE order# = 1010;

b. SELECT order# FROM orders

WHERE shipdate = (SELECT shipdate FROM orders)
AND order# = 1010;

c. SELECT order# FROM orders

WHERE shipdate = (SELECT shipdate FROM orders
WHERE order# = 1010);

d. SELECT order# FROM orders

HAVING shipdate = (SELECT shipdate FROM orders
WHERE order# = 1010);

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 12c SQL

ISBN: 978-1305251038

3rd edition

Authors: Joan Casteel

Question Posted: