What is the Subquery?
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / anil_abbireddy
Runs first,executed once,returns values to be used by the
MAIN Query
Is This Answer Correct ? | 5 Yes | 0 No |
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 |
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 |
What is scalar function?
How to process query result in pl/sql?
What does partition by mean in sql?
How do you explain an index number?
What is the best strategy to use COMMIT in a pl/sql loop?
What is flag in sql?
What is partition in sql query?
What is crud sql?
What is the fastest way of accessing a row in a table?
How do I copy a table in sql?
what is 'mysqldump'? : Sql dba
What is sql*loader and what is it used for?