Which of the following SQL statements isnt valid? a. SELECT address || city || state || zip

Question:

Which of the following SQL statements isn’t valid?

a. SELECT address || city || state || zip "Address" FROM customers WHERE lastname='SMITH';

b. SELECT * FROM publisher ORDER BY contact;

c. SELECT address, city, state, zip FROM customers WHERE lastname= "SMITH";

d. All the above statements are valid and return the expected results.

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: