Which of the following SQL statements returns all books published after March 20, 2005? a. SELECT *

Question:

Which of the following SQL statements returns all books published after March 20, 2005?
a. SELECT * FROM books WHERE pubdate > 03-20-2005;
b. SELECT * FROM books WHERE pubdate > '03-20-2005';
c. SELECT * FROM books WHERE pubdate > '20-MAR-05';
d. SELECT * FROM books WHERE pubdate > 'MAR-20-05';

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: