Answer Posted / 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 View All Answers
How do sql triggers work?
What are packages in pl sql and also explain its advantages?
How can I tell if sql is running?
What is memory optimized table?
How much ram can sql express use?
how to create a table index in mysql? : Sql dba
Why query optimization is needed?
What is restrict in sql?
What is the difference between cluster and non-cluster index?
What is bulk collect in pl sql?
what is self join and what is the requirement of self join? : Sql dba
differentiate between float and double. : Sql dba
What is a delimiter in sas?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is foreign key in sql with example?
