what is the difference between inline query and corelated
subquery
- 1 Answers
- 3922 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Explain the hierarchical database?
What is the purpose of a field in a database?
Explain why an information gap exists in most organizations.
What is foreign key in dbms?
What do you mean by starvation in dbms?
Is there a way to detect whether fbclient.dll or fbembed.dll is loaded?
What is a distributed database?
What is cliques? What is vdisk and how it will communicate with physical data storage at the time of data retrieval through amp?
What integrity rules exist in the dbms?
Define dbms.
What is db driver?
What are the two major subsystems of system r?
What is foreign key in database?
How to move a multi-file database?
Have you written applications to retrieve stored images in a table?
