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 PDE.

1128

What is the purpose of using case expression in teradata?

1064

What is teradata? Also, list out some of the primary characteristics of teradata.

1128

What are types of partition primary index (ppi) in teradata?

1100

Which is more efficient group by or distinct to find duplicates?

1129

What are the uses of client software involved in teradata?

1036

What is a clique?

1152

What is meant by a Virtual Disk?

1205

What is the primary index in teradata?

1279

Describe primary index in teradata?

1048

Highlight the advantages of PPI(Partition Primary Index).

1125

What is spool space? Why do you get spool space errors?

1078

What is stored procedure in teradata?

1085

What are the frequently used data types in teradata?

1131

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2242