Which of the following is the correct SQL clause to restrict the results of a SELECT query to only records that have a value in the range of 10 to 50 in the Hours column?
A) WHERE Hours = MIN(10) and MAX(50)
B) WHERE Hours IN [10, 50]
C) WHERE Hours = 10 and Hours = 50
D) WHERE Hours BETWEEN 10 AND 50
E) WHERE Hours RANGE 10 TO 50

Question

Quizplus · Accepted Answer

The correct clause to restrict the results of a SELECT query to only records that have a value in the range of 10 to 50 in the Hours column is WHERE Hours BETWEEN 10 AND 50. This uses the BETWEEN operator to specify the range of values.

Which of the Following Is the Correct SQL Clause to Restrict