What is the difference between correlated sub queries and
inner queries?
- 4 Answers
- 14708 Views
- I also Faced
- E-Mail Answers
Answer Posted / shafi
Correlated Sub Query:
It is a sub-query (a query nested inside another query)
that uses values from the outer query in its WHERE clause.
The sub-query is evaluated once for each row processed by
the outer query
Inner query:
It is a query that is nested inside a SELECT, INSERT,
UPDATE, or DELETE statement or inside another subquery. A
subquery can return a set of rows or just one row to its
parent query. A scalar subquery is a query that returns
exactly one value: a single row, with a single column.
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
Why are oltp database designs not generally a good idea for a data warehouse?
Explain the teradata primary index mechanics in detail with a diagram.
What is the difference between fastload and multiload? Which one is faster?
What is spool space?
What are the newly developed features of Teradata?
How is MLOAD Client System restarted after execution?
What is meant by a node?
Explain BYNET.
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What are differences between teradata and ansi session modes in teradata?
What is meant by Teradata Gateway?
What is teradata? What are some primary characteristics of teradata?
Explain the term 'columns' related to relational database management system?
what are the uses of fact table and dimension table in banking project?
Highlight a few of the advantages that ETL tools have over Teradata.
