Q. What will be the output of the following MySQL statement?
SELECT customer_id, product_id, avail_balance
FROM account
WHERE avail_balance BETWEEN 3000 AND 5000.
SELECT customer_id, product_id, avail_balance
FROM account
WHERE avail_balance BETWEEN 3000 AND 5000.
β
Correct Answer: (A)
Only those details will be shown whose as available balance form 3000 to 5000
Explanation: This question is asking about how the WHERE clause in a MySQL statement filters data.