Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between correlated sub queries and
inner queries?
- 4 Answers
- 15607 Views
- I also Faced
- E-Mail Answers
Answer Posted / shafi
Correlated Sub Query:
It is a sub-query (a query nested inside another query)
that uses values from the outer query in its WHERE clause.
The sub-query is evaluated once for each row processed by
the outer query
Inner query:
It is a query that is nested inside a SELECT, INSERT,
UPDATE, or DELETE statement or inside another subquery. A
subquery can return a set of rows or just one row to its
parent query. A scalar subquery is a query that returns
exactly one value: a single row, with a single column.
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
How to identify ppi columns?
What is meant by a Highest Cost Plan?
Highlight a few of the advantages that ETL tools have over Teradata.
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Explain BYNET.
What happens in a conflict? How do you handle that?
What is a node in teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
How can you track login parameters of users in teradata?
What are teradata utilities?
What are some commonly used bteq scripts?
How many codd's rules are satisfied by teradata database?
What is the opening step in basic teradata query script?
What are the advantages of teradata?
What is the multi-insert?
