Computer Science
The condition in a WHERE clause in a SELECT query can refer to only one value.
SQL Queries
2 Likes
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';
Answered By
1 Like
Related Questions
Fill in the blanks:
The SQL keyword _________ is used in SQL expressions to select based on patterns.
Fill in the blanks:
By default, ORDER BY clause lists the records in _________ order.
SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.
The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.