CBSE Class 12 Informatics Practices Question 73 of 79

MySQL SQL Revision Tour — Question 1

Back to all questions
1
Question

Question 1

The condition in a WHERE clause in a SELECT query can refer to only one value.

Answer

False

Reason — In SQL, the condition in a WHERE clause can refer to multiple values. We can use logical operators such as AND, OR, and NOT to combine multiple conditions. For example :

SELECT * FROM pet WHERE (species = 'cat' OR species = 'dog') AND sex = 'm';