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

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

1075

Explain and compare pros and cons of snow flake schemas?

1035

Can we collect statistics on table level?

1041

What are the joins in teradata and how many types of joins are there in teradata?

1009

Did you write stored procedures in teradata?

1137

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

1045

What do you mean by ttu in teradata?

1043

What is database exceptions in teradata?

957

How to find duplicates in a table?

1221

Difference between stored procedure and macro?

1174

What are the components provided on node?

1048

What is the multi-insert?

1037

What is dimensional modeling?

1090

Explain teradata vs. Redshift?

1032

What are the newly developed features of Teradata?

1035