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

What is cold data?

0 Answers  

---

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  

---

how to return query output in html format? : Sql dba

0 Answers  

---

What is sql injection owasp?

0 Answers  

---

---

what are ddl statements in mysql? : Sql dba

0 Answers  

---

How many joins in sql?

0 Answers  

---

What is the difference between clustered and non-clustered indexes?

0 Answers  

---

how to saw triggers output in pl/sql database?

1 Answers  

---

What is forward declaration in pl sql?

0 Answers  

---

What is optimistic concurrency control? : Transact sql

0 Answers  

---

Can We write bulk collect statement in triggers?

1 Answers   Polaris,

---