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

Can there be more than one function with a similar name in a pl/sql block?

543


how do you know if your mysql server is alive? : Sql dba

593


Is keyword pl sql?

556


What is difference between group by and partition by?

492


What are different types of functions in sql?

511






Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

525


What is trigger types in sql?

531


What is an emotional trigger?

515


Can we connect to postgresql using sql developer?

484


how to shutdown mysql server? : Sql dba

563


what is the difference between undefined value and null value? : Sql dba

562


what is bdb (berkeleydb)? : Sql dba

566


Can you have more than one trigger on a table?

530


What is trigger and stored procedure in sql?

554


How to use transactions efficiently : transact sql

540