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

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

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.

What is CYCLE/NO CYCLE in a Sequence?

2 Answers  

---

how to get second highest salary in SQL(as/4000

29 Answers   iGate,

---

What are the different types of tables in sql?

0 Answers  

---

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

0 Answers  

---

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,

---

How to use transactions efficiently : transact sql

0 Answers  

---

How much ram can sql express use?

0 Answers  

---

What is the use of partition by in sql?

0 Answers  

---

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

4 Answers   Oracle, TCS, Tecnics,

---

difference between SQL and C

1 Answers   Indus Software Technologies,

---

What are the benefits of stored procedures?

0 Answers  

---

What are the types of queries in sql?

0 Answers  

---