Which of the following SELECT statements lists the highest retail price of all books in the Family

Question:

Which of the following SELECT statements lists the highest retail price of all books in the Family category?
a. SELECT MAX (retail)

FROM books
WHERE category = 'FAMILY';

b. SELECT MAX (retail)

FROM books
HAVING category = 'FAMILY';

c. SELECT retail

FROM books
WHERE category = 'FAMILY'
HAVING MAX (retail);

d. None of the above

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: