Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between correlated sub queries and
inner queries?
- 4 Answers
- 15725 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
What are the string manipulation operators and functions associated with teradata?
What is spool space?
What is the purpose of joins in teradata?
What is the difference between teradata and oracle?
how can we analyze the locks ?
What tools would you use for that?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What do you mean by teradata sql assistant?
What are the advantages of teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
How will you solve the problem that occurs during update?
When tpump is used instead of multiload?
What are the multiload utility limitations?
What are types of partition primary index (ppi) in teradata?
If RDBMS is halted what will you do ?
