⟩ What is the difference between inline query and corelated subquery?
Inline query :
select * from emp where empno=(select max(empno) from emp);
Co-Related sub query:
Select * from emp where dob> (select distinct dob where
deptno= 10);
Note: In the Inline subquery , The main query depends upon
the outcome value of the inline sub query which is in-lined
but in case of co-related sub query the main query and sub
query both run simultaneously then the check occurs.