Sub query means A query within another query. the Sub query executed first

diff b/w sub query and co-relater query?

Question Posted / guru

3 Answers
10696 Views
iFlex, I also Faced
E-Mail Answers

Answer Posted / guru

Sub query means A query within another query. the Sub query
executed first and returns result, which is used by Main Query.

Correlated Sub query:

The sub query has a Reference with a value or values of Main
Query, Which is Called as COrrelated Sub Query.

Thanks

Guru

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a primary key? Explain

920

What is the use of non clustered index?

928

Are stored procedures compiled?

871

What is clustered index sql?

930

What is procedure and function in sql?

928

What is package in pl sql?

962

What is a pragma statement?

1201

Explain what is a view?

997

What is snowflake sql?

1011

Why is pl sql needed?

874

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

969

Is nosql relational?

893

How do I start pl sql?

895

What are the advantages of sql?

1006

Define tables and fields in a database

1080