The ________ operator in a query selects the records in which the field values listed are within the two values. A) Between B) C) = D)

Question

The ________ operator in a query selects the records in which the field values listed are within the two values. A) Between B) < > C) > = D) < =

Quizplus · Accepted Answer

The "Between" operator is used when we want to select records in which the field values are within two specified values. For example, if we want to select all employees with a salary between $50,000 and $100,000, we can use the "Between" operator as follows: 
SELECT * FROM employees
WHERE salary Between 50000 and 100000; 
This will select all employees whose salary is between $50,000 and $100,000.

The ________ Operator in a Query Selects the Records in Which