Question: Which of the following SQL statements is not valid? a. SELECT isbn FROM books MINUS SELECT isbn FROM orderitems; b. SELECT isbn, name FROM books,

Which of the following SQL statements is not valid?

a. SELECT isbn

FROM books

MINUS

SELECT isbn

FROM orderitems;

b. SELECT isbn, name

FROM books, publisher

WHERE books.pubid (+) = publisher.pubid(+);

c. SELECT title, name

FROM books NATURAL JOIN publisher

d. All the above SQL statements are valid.

Step by Step Solution

3.30 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

b SELECT isbn n... 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_60b8c12127da8_716490.pdf

180 KBs PDF File

Word file Icon

1803_60b8c12127da8_716490.docx

120 KBs Word File

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