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

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';

Step by Step Solution

3.39 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

c SELECT ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c12126e17_716411.pdf

180 KBs PDF File

Word file Icon

1803_60b8c12126e17_716411.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!