Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between correlated sub queries and
inner queries?
- 4 Answers
- 15609 Views
- I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
As said above, the main difference between a correlated Sub
Query and an inner query is that in a correlated sub query,
the inner query refers back to the column(s) in the outer
query i.e., the inner query is executed for each row of the
outer query.In the below query, the avg(salary) query is
executed for each row in the outer query.
-->>
sel * from employee as e where salary > (sel avg(salary) from
employee as b where e.deptno=b.deptno);
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the difference between fastload and multiload?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
In Teradata, how do we Generate Sequence?
List out teradata data types?
What are the various indexes in teradata? How to use them? Why are they preferred?
How to load specific no.of records using bteq, or fastload,or multiload
How do you verify a complicated sql?
What is called partitioned primary index (ppi)?
What exactly do you know about catching in teradata?
Explain some differences between mpp and smp?
What do high confidence, low confidence and no confidence mean in explain plan?
List the logical and conditional operators that are used with teradata along with their meanings?
What is the use of fallback?
Define views in teradata with general syntax.
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
