What is the difference between sub query and correlated sub query

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 20th, 2008

In sub query the inner query is executed only once. Depeding upon the results of inner query , outer query is evaluated.In correlated subquery the inner query is evaluated once for each row processed by the parent statement or outer query.

tariq_oracle

 Profile Answers by tariq_oracle Questions by tariq_oracle

• Apr 13th, 2008

subquery: required in those cases where requisted data are not known                  and always depend on inner qu...

Answer Question  Select Best Answer