A

Admin • 832.27K Points
Coach

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.

  • (A) Only those details will be shown whose as available balance form 3000 to 5000
  • (B) ft_min_len_word
  • (C) Only those details will be shown whose available balance is less than 5000
  • (D) None of the mentioned
  • Correct Answer - Option(A)
  • Views: 22
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin
This question is asking about how the WHERE clause in a MySQL statement filters data.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.