What is the difference between correlated sub queries and
inner queries?

Answer Posted / girish

I think the process of sub query is other way arround

The inner query give each value got from the SELECT to the
outer query for processing...
So ..
The outer queryis evaluated once for each row processed by
the sub-query.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Syntax for case when statement?

694


What is basic teradata query language?

716


Differentiate primary key and partition key?

654


Explain fastload in teradata?

710


What is called partitioned primary index (ppi)?

640






What is spool space? Why do you get spool space errors? How do trouble-shoot them?

620


Explain teradata utilities. What is multiload, fast load, tpump?

659


How do you see a ddl for an existing table?

667


Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

658


What's the difference between timestamp (0) and timestamp (6)?

762


What is the difference between global temporary tables and volatile temporary tables?

723


Define views in teradata with general syntax.

661


Explain parsing engine in teradata?

696


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4006


how many modules are there in telecome domain?how to explain the architecture?

1643