diff b/w sub query and co-relater query?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ganesh
sub query is select statement which is lying in clause of
another sql stament
corelated subquery:
it is row-by-row processing, in which outer sub query is
processing for every inner query result
Is This Answer Correct ? | 5 Yes | 0 No |
Sub Query : In this Inner query will execute first. Based
on that result outer query will execute.
Correlated Sub Query : Query which has reference to the
main query , means outer query will execute first based o
that result inner query will execute.
Thank you,
Suresh.
Is This Answer Correct ? | 6 Yes | 1 No |
What is data control language (dcl)?
Explain the structure of pl/sql in brief.
what are the advantages and disadvantages of views in a database? : Sql dba
What is out parameter used for eventhough return statement can also be used in pl/sql?
what is sql? : Sql dba
what is query cache in mysql? : Sql dba
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
What is full join?
how to drop an existing table in mysql? : Sql dba
what is a cursor? : Sql dba
How do you use a while loop in pl sql?
What is set serveroutput on?