Sunbquery is a query within a query where as Nested query is a subquery w

Difference between sub query and nested query ?

Question Posted / sravzzz

Answer Posted / sravzzz

Sunbquery is a query within a query where as Nested query
is a subquery which resinde in the WHERE clause.

Is This Answer Correct ?

12 Yes

15 No

Please Help Members By Posting Answers For Below Questions

What are the system predefined user roles?

982

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2189

What is oracle latest version?

1038

What is connection pooling in oracle?

911

How to create a new table in oracle?

1065

Explain the use of indexes option in exp command.

1064

How to write a query with a left outer join in oracle?

1002

What is a sub query? Describe its types?

963

What is snapshot is too old? Give and example for better understand.

1544

How to create an initialization parameter file?

982

What is the difference between a primary key & a unique key?

1037

What is a read only transaction in oracle?

970

What is the dynamic sql in oracle?

1007

What happens if the imported table already exists?

971

how to join query for one source type is oracle another source type is sql server ?

2378