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

Answers were Sorted based on User's Feedback



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

Answer / mohan

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

Is This Answer Correct ?    5 Yes 0 No

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

Answer / vimal

We can use minus query and intersect query

unmatched: records in a but not in b
select *
from a
minus
select *
from b ;

matched: recrods in a and in b
select *
from a
intersect
select *
from b ;

Is This Answer Correct ?    4 Yes 1 No

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

Answer / gowthami

i think..By using joins we can get required records.based on
your requirements we should choose left outer join or right
outer join

Is This Answer Correct ?    1 Yes 2 No

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

Answer / gowthami

i think..By using joins we can get required records.based on
your requirements we should choose left outer join or right
outer join

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Teradata Interview Questions

What is the opening step in basic teradata query script?

0 Answers  


Can any one plz provide the teradata interview questions?

10 Answers  


What is differnce between Error code and Error Level in Bteq

6 Answers   IBM,


What are different table types used in teradata?

0 Answers  


In BTEQ, how are the session-mode parameters being set?

0 Answers  






What are the various indexes in teradata? How to use them? Why are they preferred?

0 Answers  


what is single value and Multivalue ?

1 Answers   IBM, Wipro,


What is meant by a dispatcher?

0 Answers  


How many types of index are present in teradata?

1 Answers  


If the table does not have duplicates then which utility you can suggest to load the data ?

3 Answers  


Steps to create a data model?

0 Answers  


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

0 Answers  


Categories