full outer join can be used to get both unmatched and matched records..

I want to write one query
How to get Matched records and unmatched records in table?

Question Posted / mohan

Answer Posted / mohan

full outer join can be used to get both unmatched and
matched records..

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the various indexes in teradata?

997

Highlight all the modes that are present under Confidence Level.

936

What is collect statistics?

957

What are the different table types supported by teradata?

914

What is the purpose of using case expression in teradata?

974

What is meant by a Clique?

1015

Explain the term 'row' related to relational database management system?

906

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1009

How to load specific no.of records using bteq, or fastload,or multiload

1707

What are differences between teradata and ansi session modes in teradata?

1120

How can bottlenecks be identified?

972

What are the available primary index types?

1170

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1123

What is meant by a Highest Cost Plan?

1010

What do you mean by tpt in teradata?

979