Interested to Buy Any Domain ? << Click Here >> for more details...
I want to write one query
How to get Matched records and unmatched records in table?
- 4 Answers
- 10991 Views
- TCS, I also Faced
- E-Mail Answers
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 are the various indexes in teradata? How to use them?
in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?
Where we use PPI in real time??? What is the disadvantages of PPI?
teradata support to automatically increase the character length or not?
How do you determine the number of sessions?
Explain the term 'row' related to relational database management system?
What is meant by a Virtual Disk?
What is difference between user and database in teradata?
What is the command in bteq to check for session settings ?
What is Join Index in TD and How it works?
How many sessions of MAX is PE capable of handling at a particular time?
Difference between multiload and tpump?
Teradata 
