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
- 11041 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
What do you mean by tpt in teradata?
What are the components used in smp and massively parallel processing (mpp) machines?
What is stored procedure in teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
What are the functions of a teradata dba?
Difference between multiload and tpump?
What are the string manipulation operators and functions associated with teradata?
Is multi insert ansi standard?
What is the use of teradata system software?
Which is faster fastload or multiload?
Different phases of multiload?
In Teradata, what is the significance of UPSERT command?
How to find duplicates in a table?
What are the 5 phases in a multiload utility?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
