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
4461 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 default value database?

983

What is sonicmq?

887

How to create student table through query with a numeric column of ID and Name of Chaeacter and D-O-B with date type in database What will be the query for this purpose?

990

What is father dbms?

1318

What is file manager?

900

What is dbms architecture?

1045

What are types of dbms?

979

Are databases stored on servers?

1021

What is database management system explain?

916

What is ims software environment?

892

Which two statements are true about a foreign key?

951

what is storage manager?

910

What are different type of normalization?

963

What is the role of database server in database management system?

864

What are the importance of partitioning in dbms?

945