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.

Explain the working of foreign key?

0 Answers  

---

What is meant by Materialized view?

2 Answers   iGate, Marlabs, Polaris,

---

How are sql commands classified?

0 Answers  

---

how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,

---

How do I access sql anywhere database?

0 Answers  

---

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  

---

What are schema-level triggers?

0 Answers  

---

What is the difference between having clause and where clause?

0 Answers  

---

How do you optimize a stored procedure query?

0 Answers  

---

What is integrity constraints?

5 Answers   Ramco, Satyam,

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

0 Answers  

---

Differences between UNIQUE and DISTINCT in select statements

26 Answers   ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

---