What is Correlation and why we need correlating statements?

Correlation is used to obtain data which is required for each run of the script and which are generated by nested queries. Correlation provides the value to avoid errors arising out of duplicate values and also optimizing the code. The Reason for Correlating the statements are:

- To simplify or optimize the code.
- To generate dynamic data.
- To accommodate unique data records.