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's the difference between timestamp (0) and timestamp (6)?

1123

What is the multi-insert?

963

Explain the types of join supports by teradata?

935

Explain fallback in teradata?

985

What are the different softwares used with their functions in teradata?

966

Explain the meaning of Amp?

1034

What are the uses of bynets in multi-node systems?

968

When tpump is used instead of multiload?

1040

any one answer me how they can analyzing the project using data ware housing?

2407

How many types of joins are there in teradata?

914

Difference between stored procedure and macro?

1109

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

929

What is meant by a Channel Driver?

1142

What are the components provided on node?

985

Highlight the differences between Primary Key and Primary Index.

1016