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 Teradata performance tuning and optimization?
Explain the term 'primary key' related to relational database management system?
What is teradata? What are some primary characteristics of teradata?
What are the multiload utility limitations?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Highlight the differences between Primary Key and Primary Index.
What are the uses of bynets in multi-node systems?
Why do you get spool space errors? How do trouble-shoot them?
What is the difference between fastload and multiload?
Define views in teradata with syntax.
Explain the term 'database' related to relational database management system?
How to run a query in teradata?
What are default access rights in teradata? What explicit right can be given to a user?
What is meant by a dispatcher?
What is stored procedure in teradata?