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
D
Business
You might also like to view...
The different between a job, career, and a calling is the extent to which the ____ of the person is defined by the role itself.
a. gift b. investment c. insult d. sacrifice e. waste of resource
Business
The advantages of an in-house advertising department include the following, except:
A) greater expertise and talent on creating ads B) lower costs C) the message can be aligned with the brand and other company communications D) the CEO and upper management can work closely with the marketing team
Business