The correct answer is D. And.
The And operator is a logical operator that is used to combine two or more conditions. A record will be selected only if all of the conditions are satisfied.
The Or operator is a logical operator that is used to combine two or more conditions. A record will be selected if any of the conditions are satisfied.
The If or operator is not a valid operator.
The Range operator is used to select records that fall within a specified range of values.
For example, the following query will select all records where the Age
column is greater than 18 and less than 65:
SELECT * FROM Customers WHERE Age > 18 AND Age < 65;