Type I nested queries can be used like loops and Type II nested queries can be used like procedures in a programming language.

Question

Quizplus · Accepted Answer

Type I and Type II nested queries refer to the classification of subqueries in SQL, where Type I (non-correlated subqueries) execute once before the main query, and Type II (correlated subqueries) execute once for each row processed by the main query. Neither directly corresponds to loops or procedures in the way programming languages use these constructs.

Type I Nested Queries Can Be Used Like Loops and Type