What is the difference between correlated sub queries and
inner queries?
Answer Posted / girish
I think the process of sub query is other way arround
The inner query give each value got from the SELECT to the
outer query for processing...
So ..
The outer queryis evaluated once for each row processed by
the sub-query.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is a sparse index?
What is the command in bteq to check for session settings ?
Which is faster fastload or multiload?
What do you mean by fastexport in teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What are the uses of bynets in multi-node systems?
How do you determine the number of sessions?
What is stored procedure in teradata?
What is the use of having index on table?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What interface is used to connect to windows based applications?
What is the purpose of indexes?
What do you mean by caching in teradata?
Explain the parallel data extension in teradata?
Difference between multiload and tpump?