1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

diff b/w sub query and co-relater query?

Question Posted / g.rajesh

Answers were Sorted based on User's Feedback



diff b/w sub query and co-relater query?..

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

diff b/w sub query and co-relater query?..

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

diff b/w sub query and co-relater query?..

Answer / suresh somayajula

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

Post New Answer

More SQL PLSQL Interview Questions

what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,

what is bulk bind

4 Answers   TCS,

What are the possible values that can be stored in a boolean data field?

0 Answers  

suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  

I want to execute a piece of code before calling a procedure. How to achieve it?

1 Answers   Oracle,




i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject

8 Answers  

what is the different between now() and current_date()? : Sql dba

0 Answers  

What are the types of SQL Statement?

3 Answers  

How do you display "13th of November, 17 days left for month end" without hardcoding the date.

3 Answers  

Is it possible to update views?

0 Answers  

What are the different types of joins and explain them briefly.

3 Answers  

explain access control lists. : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories