A correlated subquery is one that refers to a table column that is not in the FROM clause. The column can appear in either the Projection clause or the WHERE clause. Correlated subqueries, in general, degrade performance.
Vishalini.R Answered question July 6, 2023
