Answers

Question and Answer:

  Home  Database Management

⟩ 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.

 125 views

More Questions for you: