What is the Subquery?

Question Posted / guest

4 Answers
6826 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the Subquery?..

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

Is This Answer Correct ?

6 Yes

0 No

What is the Subquery?..

Answer / anil_abbireddy

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

Is This Answer Correct ?

5 Yes

0 No

What is the Subquery?..

Answer / ramesh

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

Is This Answer Correct ?

0 Yes

0 No

What is the Subquery?..

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer