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 UNIQUE pubid,title FROM books;
B) both b and c
C) SELECT DISTINCT pubid FROM books;
D) SELECT DISTINCT category FROM books;

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 UNIQUE pubid,title FROM books; 
B) ​both b and c 
C) ​SELECT DISTINCT pubid FROM books; 
D) ​SELECT DISTINCT category FROM books;

Quizplus · Accepted Answer

This query selects the distinct values in the pubid column, which should result in fewer than five rows. The other queries do not limit the number of rows returned and could potentially return more than five.

Contents of the BOOKS Table