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
10864 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

How do I start sql from command line?

1021

What is sharding in sql?

972

How do you know if a relationship is 2nf?

942

What is java sql driver?

1112

What does fetching a cursor do?

1083

Is mariadb nosql?

1040

How many types of sql are there?

986

Which data dictionary views have the information on the triggers that are available in the database?

1234

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

1145

what is data control language? : Sql dba

1024

Why sql query is slow?

988

What are all ddl commands?

1081

Explain the order of sql statement execution?

1043

How to take user input in pl sql?

1161

What is integrity in sql?

1040