Which of the following criterion expressions searches for a YearsWorked field that is between 10 and 20? A)In(10,20) B) 10

Name: Which of the following criterion expressions searches for a YearsWorked field that is between 10 and 20? A)In(10,20) B) >10< 20 C)Between #10 and 20# D)Between 10 and 20
Brand: Quizplus
Rating: 4.8 (45 reviews)

Question

Which of the following criterion expressions searches for a YearsWorked field that is between 10 and 20?
A)In(10,20)
B) >10< 20
C)Between #10 and 20#
D)Between 10 and 20

Quizplus · Accepted Answer

The correct syntax to search for a range of values in SQL is "BETWEEN...AND...", making "Between 10 and 20" the correct choice for searching a YearsWorked field that is between 10 and 20.

Which of the Following Criterion Expressions Searches for a YearsWorked