Question: The following two SQL statements will produce different results. Select last _ name, first _ name from customer where state = ' MA ' or

The following two SQL statements will produce different results.
Select last_name, first_name
from customer
where state ='MA' or state =?'NY' or state ='NJ' or state =NH' or state ='CT';
Select last_name, first_name
from customer
where state in ('MA','NY','NJ','NH','CT');
True
False
 The following two SQL statements will produce different results. Select last_name,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!