🎴 Flashcard Mode

Oracle PL/SQL and SQL Fundamentals

Card1 / 20
Mastered0
Review0
QuestionClick to flip

Which operator can be used with a multiple-row subquery?

AnswerClick to flip back
A
NOT IN
💡 Explanation:

The NOT IN operator is designed to work with multiple-row subqueries, comparing a value against a list of values returned by the subquery. Operators like =, LIKE, and BETWEEN expect single values.

Change Mode