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
What is row_number () in sql?
what is a composite primary key ? : Sql dba
What is the use of function in sql?
Show the cursor attributes of pl/sql.
What is mutating sql table?
What are the events on which a database trigger can be based?
Do foreign keys improve performance?
What is an alias command?
What are conditional predicates?
What are the benefits of triggers?
What is scalar and vector?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
Can a trigger call a stored procedure?
How do I upgrade sql?
What is trigger and how to use it in sql?
