Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between correlated sub queries and
inner queries?
- 4 Answers
- 15771 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 spool space? Why do you get spool space errors? How do trouble-shoot them?
What is TPD?
what are the day to day activities of teradata DBA ?
How do you set the session mode parameters in bteq?
Which is faster fastload or multiload?
Explain the term 'database' related to relational database management system?
Discuss the advantages of using partitioned primary index in a query?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are default access rights in teradata? What explicit right can be given to a user?
How do you define Teradata?
What is teradata and why it is used?
What interface is used to connect to windows based applications?
What is stored procedure in teradata?
What are the frequently used data types in teradata?
What is meant by a dispatcher?
