Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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,

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

how to convert numeric values to character strings? : Sql dba

0 Answers  

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

0 Answers   BT,

What is implicit cursor in pl sql?

0 Answers  

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

4 Answers   Tech Mahindra,

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

5 Answers   TCS,

What is the source code of a program?

0 Answers  

How do you go back in sql?

0 Answers  

Where the Pre_defined_exceptions are stored ?

2 Answers  

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

1 Answers   TCS,

What is the advantage of nosql?

0 Answers  

How can we avoid duplicating records in a query?

0 Answers