Contents of BOOKS table

-Based upon the contents of the BOOKS table in the accompanying figure,which of the following SQL statements will retrieve all books published by the publisher assigned Pubid 1?
A) SELECT * FROM books WHERE pubid LIKE "1";
B) SELECT * FROM books WHERE pubid = 1;
C) SELECT * FROM books WHERE pubid 1;
D) both a and b

Question

Contents of BOOKS table
  ​
-​Based upon the contents of the BOOKS table in the accompanying figure,which of the following SQL statements will retrieve all books published by the publisher assigned Pubid 1?
A) ​SELECT * FROM books WHERE pubid LIKE "1"; 
B) ​SELECT * FROM books WHERE pubid = 1; 
C) ​SELECT * FROM books WHERE pubid > 1; 
D) ​both a and b

Quizplus · Accepted Answer

Choice A is incorrect because the LIKE operator is used for string matching and the Pubid is an integer in this case. Choice C is incorrect because it will retrieve all books with Pubid greater than 1, which includes books published by publishers other than the one assigned Pubid 1. Choice B is the correct answer because it matches the Pubid assigned to the publisher in question.

Contents of BOOKS Table