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 |
How do I find duplicates in sql?
What are joins in sql?
how to include comments in sql statements? : Sql dba
there are .......different types of serializability
What are the steps for performance tuning.
Can we create view in stored procedure?
Why do we use view in sql?
Can we update views in sql?
What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?
How can I get the number of records affected by a stored procedure?
suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??
How can we store rows in PL/SQL using array?