Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between inline query and corelated
subquery
- 1 Answers
- 4486 Views
- I also Faced
- E-Mail Answers
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 |
Which is the best database?
What are the types of database servers?
Compare non-clustered and clustered index
what are the different levels of database schema?
What are the database objects?
What is meant by database server?
Enlist the advantages of dbms.
What is the importance of database in an organization?
From where the Transactions per rollback segment is derived ?
What is metadata and why should I use it?
What are the types of database explain each of them briefly?
Explain 5nf?
-
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)
