Inline query : select * from emp where empno=(select max(empno) from emp);

what is the difference between inline query and corelated
subquery

Question Posted / sudipta santra

1 Answers
4424 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

Please Help Members By Posting Answers For Below Questions

What is ims software environment?

868

Explain database partitioning and its importance.

915

What is the role of tables in database?

907

What entity means?

823

What is 2nf in dbms?

1022

Why do not you use gnu autoconf or scons for building?

899

Can you have more than one cursor open at any one time in a program ?

900

Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?

903

Mention some advantages of using dbms.

895

What is natural key?

940

What do you understand by index hunting?

1098

What are the advantages of database?

893

What is type of end users?

763

What are the benefits of modeling?

994

What are different types of transaction isolation levels?

963