The Following Two SQL Statements Will Produce Different Results

question 75

True/False

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');

---

Definitions:

Historical School

A school of jurisprudence that uses traditions as the model for future laws and behavior. Also called tradition or custom.

Statute

A written law passed by a legislative body at the federal or state level, setting forth regulations, provisions, and penalties.

Common Law

A legal system based on custom and court rulings rather than written laws, primarily in English-speaking countries.

Cell Phone Usage

The rules or guidelines governing the use of mobile phones in various contexts, such as driving or in certain public spaces.