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

Highlight all the modes that are present under Confidence Level.

964

What is teradata and why it is used?

1076

Explain some differences between mpp and smp?

1081

How do you determine the number of sessions?

1049

What is the difference between teradata and oracle?

1006

Difference between stored procedure and macro?

1152

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1714

What is the difference between union and union all in teradata?

1109

Highlight the limitations of TPUMP Utility.

1100

Describe the between keyword in teradata?

1023

How to view every column and the columns contained in indexes in teradata?

1026

what are the uses of fact table and dimension table in banking project?

4544

How many tables can you join in v2r5?

1050

How can bottlenecks be identified?

1003

What are the functions of a Parser?

1089