Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between correlated sub queries and
inner queries?
- 4 Answers
- 15892 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
Describe primary index in teradata. And what are the available primary index types?
Is multi insert ansi standard?
What are aggregate tables? How do you design them using teradata?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
Explain the types of join supports by teradata?
What are the 5 phases in a multiload utility?
Difference between stored procedure and macro?
What do high confidence, low confidence and no confidence mean in explain plan?
In the Primary Index, what is the score of AMPs that are actively involved?
Describe the between keyword in teradata?
Can we collect statistics on table level?
During the Display time, how is the sequence generated by Teradata?
What are the steps to create a data model?
List out all forms of LOCKS that are available in Teradata.
Explain the term 'primary key' related to relational database management system?
