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
- 10894 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What are the various reporting tools in the market?
What is difference between user and database in teradata?
What are the primary characteristics of the Teradata.
What are the different table types that are supported by teradata?
What is upsert statement in teradata?
Name the five phases that come under MultiLoad Utility.
What is the function of parser component in teradata?
What is logical data model?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
How to select first n records in teradata?
Why teradata is used?
Explain teradata utilities. What is multiload, fast load, tpump?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
