The following two SQL statements will produce the same results. Select last_name, first_name from customer where credit_limit 99 and credit_limit

Question

The following two SQL statements will produce the same results.
Select last_name, first_name
from customer
where credit_limit > 99 and credit_limit < 10001;
Select last_name, first_name
from customer
where credit_limit between 100 and 10000;

Quizplus · Accepted Answer

Both SQL statements are selecting the last name and first name of customers whose credit limit is between $100 and $10,000. The first SQL statement specifies the range using greater than and less than operators, while the second SQL statement uses the BETWEEN operator. However, the range being selected is the same in both cases.

The Following Two SQL Statements Will Produce the Same Results