Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between correlated sub queries and
inner queries?
- 4 Answers
- 15769 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
How to view every column and the columns contained in indexes in teradata?
What are tpump utility limitations?
What is meant by a Least Cost Plan?
Can you fastexport a field, which is primary key by putting equality on that key?
Explain amp in teradata?
List out all forms of LOCKS that are available in Teradata.
What are aggregate tables? How do you design them using teradata?
any one answer me how they can analyzing the project using data ware housing?
What is the difference between global temporary tables and volatile temporary tables?
What is a level of granularity of a fact table?
Explain and compare pros and cons of snow flake schemas?
In BTEQ, how are the session-mode parameters being set?
What is bteq script in teradata?
What is the difference between teradata and oracle?
What is multi insert?
