A self-contained subquery is independent of the outer query It can be executed stand-alone. It is executed once and the result is used by the outer query. (As a result,it is generally more efficient ...