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
- 10895 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 |
Why Multiload does not supports USI and supports NUSI?
what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)
What do you mean by tpt in teradata?
Explain teradata vs. Redshift?
In your project what type of issues and errors you facing in Teradata
What is SQL Assistence?please eample
we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.
5 Answers Accenture, Cognizant,
What is partitioned primary index (ppi)?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What is the purpose of using case expression in teradata?
What are the available primary index types in teradata.
What is primary index and secondary index?
Teradata 
