what is the difference between inline query and corelated subquery

what is the difference between inline query and corelated
subquery

Question Posted / sasmita

1 Answers
3772 Views
I also Faced
E-Mail Answers

what is the difference between inline query and corelated subquery ..

Answer / sudipta santra

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.

Is This Answer Correct ?

2 Yes

10 No

Post New Answer

More Database Management Interview Questions

What are the benefits of modeling?

0 Answers

What is sql in dbms?

0 Answers

Segregate database technology's development.

0 Answers

Explain the terms database and dbms?