What is the difference between correlated sub queries and
inner queries?
- 4 Answers
- 14700 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
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What is the use of fallback?
What are default access rights in teradata? What explicit right can be given to a user?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Why do you get spool space errors? How do trouble-shoot them?
What happens when a node suffers a downfall?
What is the function of parser component in teradata?
What is node? How many nodes and amps used in your previous project?
Explain parsing engine in teradata?
What are the different design perspectives used in teradata?
How many sessions of MAX is PE capable of handling at a particular time?
How to identify ppi columns?
Describe primary index in teradata. And what are the available primary index types?
What is the use of teradata system software?
What are tpump utility limitations?
