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
- 10992 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 can you track login parameters of users in teradata?
What is TPD?
What are the components used in smp and massively parallel processing (mpp) machines?
What are the different methods ot loading a dimension table? A fact table etc?
What is dimensional modeling?
Explain BYNET.
What is meant by a dispatcher?
what is object level locking ? where do appear this type of locking ?
What is meant by a Clique?
What are the frequently used data types in teradata?
How do you define Teradata?
Explain the parallel data extension in teradata?
What is bteq script in teradata?
What are some commonly used bteq scripts?
What does sleep function does in fast load?
