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

Does sqlite need a server?

0 Answers  

---

how mysql optimizes distinct? : Sql dba

0 Answers  

---

How do I view tables in sql developer?

0 Answers  

---

I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.

1 Answers  

---

Is mariadb a nosql database?

0 Answers  

---

Describe sql comments?

0 Answers  

---

Is there any restriction on the use of union in embedded sql?

0 Answers  

---

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

---

How to perform a loop through all tables in pl/sql?

4 Answers   Evosys, MBT,

---

select 10 from dual; y its showing all the rows with 10?

1 Answers  

---

how to use myisamchk to check or repair myisam tables? : Sql dba

0 Answers  

---

When do we use triggers?

0 Answers  

---