KnowledgeBoat Logo

Class - 12 CBSE Computer Science — Assertion Reason Type Questions

Assertion. Both BETWEEN and IN operators can choose from a list of values.

Reason. The value ranges and a list of values are interpreted in the same way in SQL.

SQL Queries

2 Likes

Answer

(c)

Assertion is true but Reason is false.

Explanation
Both BETWEEN and IN operators can select values from a list. The BETWEEN operator defines a range of values into which column values must fall to make the condition true. This range includes both lower and upper values. In contrast, the IN operator is used to specify a list of values. It selects values that match any value in the given list of values. Therefore, while both operators involve selecting values from a list, they operate differently in SQL, distinguishing between value ranges and specific value lists.

Answered By

3 Likes