Question

Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.

(a) SELECT * FROM weather WHERE humidity IN (63 to 79)

(b) SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)

(c) SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79

(d) SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

The question was asked during an interview.

I need to ask this question from Basic SQL topic in section Laying the Foundation of SQL Server

Answer 1

Correct choice is (c) SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79

The explanation: The BETWEEN operator is used to select values within a range.