I want to write one query
How to get Matched records and unmatched records in table?
Answers were Sorted based on User's Feedback
Answer / mohan
full outer join can be used to get both unmatched and
matched records..
Is This Answer Correct ? | 5 Yes | 0 No |
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 |
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 |
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 |
What is the opening step in basic teradata query script?
Can any one plz provide the teradata interview questions?
What is differnce between Error code and Error Level in Bteq
What are different table types used in teradata?
In BTEQ, how are the session-mode parameters being set?
What are the various indexes in teradata? How to use them? Why are they preferred?
what is single value and Multivalue ?
What is meant by a dispatcher?
How many types of index are present in teradata?
If the table does not have duplicates then which utility you can suggest to load the data ?
Steps to create a data model?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?