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
What are the benefits of triggers?
what is acid property in database? : Sql dba
what is bdb (berkeleydb)? : Sql dba
How to get list of all tables from a database?
How do you write a subquery?
What is normalization in a database?
what is uncommittable transactions? : Transact sql
What are two statement types in sql?
What is the difference between the implicit and explicit cursors?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
how to enter numeric values as hex numbers? : Sql dba
how to shut down the server with 'mysqladmin'? : Sql dba
What are tuples in sql?
when MSQL8.0 is in market
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?