Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between correlated sub queries and
inner queries?
- 4 Answers
- 15899 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
What are tpump utility limitations?
Explain teradata utilities. What is multiload, fast load, tpump?
What is the multi-insert?
Explain and compare pros and cons of snow flake schemas?
Explain the term 'tables' related to relational database management system?
Explain the parallel data extension in teradata?
Highlight a few of the important components of Teradata?
How can we check the version of Teradata that we are using currently?
What are the main components of teradata system?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What do you mean by fastexport in teradata?
What is meant by a Highest Cost Plan?
Difference between multiload and tpump?
What is the use of virtual processor connectivity in teradata?
What do you mean by tpt in teradata?
