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 |
What do you understand by aggregation and atomicity?
What do you understand by proactive, retroactive and simultaneous update?
What are its two major subsystems of r?
What is the purpose of a database middleware other than translating the jdbc api calls to multiple vendor specific dbms calls?
What do you understand by cursor? Mention the different types of cursor?
What are fact tables and dimension tables ? What is dimensional modeling and star schema design
What is a database in a website?
What is foreign key in database?
Enlist various types of interactions created by dbms?
Is driver a software?
What is the use of ROWS option in EXP command ?
What are the disadvantages of a database?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)