What is the Subquery?

Answers were Sorted based on User's Feedback



What is the Subquery?..

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

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

More SQL PLSQL Interview Questions

What is scalar function?

0 Answers  


How to process query result in pl/sql?

0 Answers  


What does partition by mean in sql?

0 Answers  


How do you explain an index number?

0 Answers  


What is the best strategy to use COMMIT in a pl/sql loop?

3 Answers  






What is flag in sql?

0 Answers  


What is partition in sql query?

0 Answers  


What is crud sql?

0 Answers  


What is the fastest way of accessing a row in a table?

5 Answers   TCS,


How do I copy a table in sql?

0 Answers  


what is 'mysqldump'? : Sql dba

0 Answers  


What is sql*loader and what is it used for?

0 Answers  


Categories