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
- 10854 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 is partitioned primary index (ppi)?
how can we analyze the locks ?
Highlight the advantages of PPI(Partition Primary Index).
Define views in teradata with syntax.
What is primary index and secondary index?
Describe primary index in teradata?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What is teradata?
How many types of joins are there in teradata?
List out teradata data types?
What is the difference between fastload and multiload? Which one is faster?
What does Amp contain and what are all the operations that it performs?
What is a level of granularity of a fact table?
What is the maximum number of dml can be coded in a multiload script?
Highlight the differences between Primary Key and Primary Index.
