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 statements use the same logical expression to filter the customer table, so they will produce the same results.

The Following Two SQL Statements Will Produce the Same Results