Which operator selects values matching any value in a given list?
AON
BOF
CAT
DIN
Answer & Solution
Correct answer: D. IN
1. Sometimes a column must match one of several named values.
2. Writing many OR conditions is avoidable.
3. The IN operator selects values that match any value in the given list.
4. So the answer is IN.
_Source: syllabus Computer Science, Ch 9 'Structured Query Language (SQL)'_
Keep practising Structured Query Language
Browse all Structured Query Language questions for IGNOU MCA, or explore more Computer Science topics.