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
Explain and compare pros and cons of snow flake schemas?
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?
Highlight the limitations of TPUMP Utility.
While creating table my dba has fallback or no fallback in his ddl. What is that?
Explain Teradata performance tuning and optimization?
What is a dimension table?
What are the 5 phases in a multiload utility?
Highlight the points of differences between the database and user in Teradata.
Highlight all the modes that are present under Confidence Level.
What is the maximum number of dml can be coded in a multiload script?
What is the command in bteq to check for session settings ?
What are the steps involved after the disk manager passes the request?
Explain fallback in teradata?
Why does varchar occupy 2 extra bytes?
How to Extract data from multiple legacy systems?