Contents of the PUBLISHER table

-Based upon the contents of the PUBLISHER table, which of the following SELECT statements will display the publisher's name first in the results?
A) SELECT * FROM publisher;
B) SELECT pubid, contact FROM publisher;
C) SELECT name, publisherID FROM publishers;
D) none of the above

Question

Contents of the PUBLISHER table
 
-Based upon the contents of the PUBLISHER table, which of the following SELECT statements will display the publisher's name first in the results?
A) SELECT * FROM publisher; 
B) SELECT pubid, contact FROM publisher; 
C) SELECT name, publisherID FROM publishers; 
D) none of the above

Quizplus · Accepted Answer

The correct SQL statement should be "SELECT name FROM publisher;" to display the publisher's name first. None of the given options do this correctly.

Contents of the PUBLISHER Table