Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between correlated sub queries and
inner queries?
- 4 Answers
- 15898 Views
- I also Faced
- E-Mail Answers
Answer Posted / vinay sir(datawarehousing tech
Guys,
First of all the question is not proper,it is supposed to
be "the difference between correlated sub queries and
simpe sub queries".
Corelated and Simple, both are Subqueries(having inner and
outer queries) but the way they execute is different.
Simple Subquery:Inner query executed first and then outer
query. Inner query executed only one time.
Corelated Sub query:Outer query is executed first and then
inner query.Outer query is executed many times.
Please find a common example where you can see the
execution difference.
Simple Subquery: select max(sal) from emp where sal not in
(select max(sal) from emp)
Corelated: Select a.sal from emp e where 1=(select count
(distinct(b.sal)) from emp b where a.sal<b.sal)
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are the string manipulation operators and functions associated with teradata?
Explain teradata vs. Redshift?
What are the various etl tools in the market?
What are the various reporting tools in the market?
How can bottlenecks be identified?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Highlight the need for Performance Tuning.
What is TPD?
What are the joins in teradata and how many types of joins are there in teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What is collect statistics?
What are the 5 phases in a multiload utility?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is teradata? What are some primary characteristics of teradata?
What exactly do you know about catching in teradata?
