Contents of the BOOKS table

-Based upon the contents of the BOOKS table, which of the following SQL statements will display five rows in its results?
A) SELECT DISTINCT category FROM books;
B) SELECT DISTINCT pubid FROM books;
C) SELECT UNIQUE pubid, title FROM books;
D) both b and c

Question

Contents of the BOOKS table
 
-Based upon the contents of the BOOKS table, which of the following SQL statements will display five rows in its results?
A) SELECT DISTINCT category FROM books; 
B) SELECT DISTINCT pubid FROM books; 
C) SELECT UNIQUE pubid, title FROM books; 
D) both b and c

Quizplus · Accepted Answer

Option A will only display distinct categories in the books table, not specific rows. Option C uses the SQL keyword 'UNIQUE' which is not a valid keyword. Option D is not necessary as option B is the only valid option that will display specific rows, in this case the distinct pubid values.

Contents of the BOOKS Table