EXISTS, IN and correlated subqueries
QuizMediumAsked in: TCS
Which statement is true?
- EXISTS is true as soon as the subquery returns any row; what the subquery selects does not matter
- NOT IN and NOT EXISTS always return the same rows
- A correlated subquery is computed once for the whole query
- IN can only take a fixed list of values, never a subquery
This question is part of Pro+
Pro+ opens every question in Interview Prep and the mock interview. Every article and the first 2 questions of each topic stay free. Hands-on Selenium and API tasks follow their course lesson's own lock.