Answer / suresh kumar somayajula

SELECT Statement which is embedded in another class of
SELECT statement is nothing but "Sub-Query".

In this ..Inner query will execute first.based on that
result outer query will execute.

Thank you,
Suresh

Answer / anil_abbireddy

Runs first,executed once,returns values to be used by the
MAIN Query

Answer / ramesh

A sub query is a query and it is deepened main query on the another query is called as a sub-query.

Answer / rashmi

Query inside a query is called sub query. Always to execute successfully the outer query depends on the output of inner query.
it is if 4 types.

>Scalar sub query
>Corelated sub query
>Nested sub query
>Inline view

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d

4 Answers  

---

what are set operators in sql? : Sql dba

0 Answers  

---

If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?

2 Answers  

---

What are %type and %rowtype for?

0 Answers  

---

Is left join same as join?

0 Answers  

---

Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,

---

What is procedure and function?

0 Answers  

---

How does sql*loader handles newline characters in a record? : aql loader

0 Answers  

---

what is table? : Sql dba

0 Answers  

---

what are ddl statements in mysql? : Sql dba

0 Answers  

---

What is a data manipulation language?

0 Answers  

---

What sql does db2 use?

0 Answers  

---