Question

Based upon the contents of the BOOKS table, which line of the following SQL statement contains an error?

1. SELECT title, pubid, cost, retail
2. FROM books
3. WHERE (pubid, cost)
4. (SELECT pubid, cost)
5. FROM books
6. WHERE pubid = 3);

Answer 1

The answer is "Option 4"

Step-by-step explanation:

In the given question line 4 is incorrect because it uses the select command, which selects "pubid and cost" that is already defined inline 3. This statement selects one or more a collection of records from the tables. It also recovers more row across any table that server and correct choices can be described as follows:

• In the given choices, except line 3 all were correct because first, it selects column names from the table "book".
• After selecting column names it and defines condition were pubid value is 3.