what is the difference between the query and corelated
query

Answer Posted / saurabh

When 1st main query is executed then the result of the main
query is used in teh where clause of subquery then this
type of subquery is called as co-related sub query.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the benefits of triggers?

589


what is acid property in database? : Sql dba

555


what is bdb (berkeleydb)? : Sql dba

558


How to get list of all tables from a database?

622


How do you write a subquery?

513






What is normalization in a database?

603


what is uncommittable transactions? : Transact sql

558


What are two statement types in sql?

531


What is the difference between the implicit and explicit cursors?

518


Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

541


how to enter numeric values as hex numbers? : Sql dba

561


how to shut down the server with 'mysqladmin'? : Sql dba

537


What are tuples in sql?

557


when MSQL8.0 is in market

1592


Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

802