Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between correlated sub queries and
inner queries?
- 4 Answers
- 15726 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
Can we collect statistics on table level?
How is MLOAD Client System restarted after execution?
How to run a query in teradata?
What is the use of having index on table?
What is the command in bteq to check for session settings ?
What are the enhanced features in teradata v2r5 and v2r6?
Difference between multiload and tpump?
In the Primary Index, what is the score of AMPs that are actively involved?
What is a sparse index?
Highlight the advantages of PPI(Partition Primary Index).
What are the frequently used data types in teradata?
Did you write stored procedures in teradata?
What is a node in teradata?
How do you define Teradata?
What is meant by a node?
