Question

In a WHERE clause, logical operators are evaluated before comparison operators.

A) True
B) False

Answer 1

In a WHERE clause, logical operators are examined before to comparison operators.

Step-by-step explanation:

Logical operators are examined before comparison operators in a WHERE clause. This means that the logical operators such as AND, OR, and NOT are processed first, followed by the comparison operators such as =, >, <, etc.

For example, consider the following SQL query:

SELECT * FROM employees WHERE salary > 50000 AND age < 30;

In this query, the logical operator AND is evaluated before the comparison operators > and <. This means that both conditions must be true for a row to be selected.