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
- 10858 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 is meant by a Channel Driver?
Which is faster fastload or multiload?
can we join volatile table with general table an global temporary table with general table ?
What does sleep function does in fast load?
can we load 10 millions of records into target table by using tpump?
What are the differences between TerdataV2R5 and V12 Versions please??
Find 2 highest sal from each dept who have completed 5 year in org
What is inner join and outer join?
What are the updated features of teradata?
write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
What is the difference between teradata and oracle?
List out all forms of LOCKS that are available in Teradata.
Teradata 
