Which SQL operator allows you to check if a column value matches any item contained within a comma-separated list of explicit values? MCQ with Answer and Explanation
Which SQL operator allows you to check if a column value matches any item contained within a comma-separated list of explicit values?
A. BETWEEN
B. IN
C. LIKE
D. EXISTS
Answer: Option B
Solution (By JKSSB Mock Tests)
The IN operator allows you to specify multiple literal values or a subquery inside a WHERE clause, testing if an attribute matches any element in the list.
Explanation:
UPDATE is a DML statement because it is used to modify existing data values within rows of a database table, rather than modifying the structural schema.
No comments yet. Be the first to start the discussion!