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
πŸ’¬ Discuss
βœ… 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.
Explanation by: Vinay
This question is asking about how the WHERE clause in a MySQL statement filters data.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
115
Total Visits
πŸ“½οΈ
1 y ago
Published
πŸŽ–οΈ
Vinay
Publisher
πŸ“ˆ
87%
Success Rate