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

Why do we use procedures in sql?

0 Answers  

---

How is pl sql different from sql?

0 Answers  

---

What are the two types of periodical indexes?

0 Answers  

---

Define commit?

0 Answers  

---

Why do we need a foreign key?

0 Answers  

---

What is meant by user defined function?

0 Answers  

---

Does pl sql work in mysql?

0 Answers  

---

Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

5 Answers   Infosys,

---

how u can find the n row from a table?

19 Answers   Tech Mahindra,

---

what happens if null values are involved in expressions? : Sql dba

0 Answers  

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

0 Answers   Wipro,

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

0 Answers  

---