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
10875 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 sql exception?

974

What is difference between cursor and trigger?

1074

What operating systems are supported by oracle sql developer?

965

What is an emotional trigger?

1005

What is a schema sql?

1152

What is the basic form of sql query?

943

What is insert command in sql?

1128

Is and as keyword in pl sql?

961

Is id a reserved word in sql?

1145

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

1145

What is primary key and foreign key?

960

what are the performance and scalability characteristics of mysql? : Sql dba

996

What is sql injection vulnerability?

944

Can we call stored procedure in function?

957

What can you do with pl sql?

1094