I want to write one query
How to get Matched records and unmatched records in table?
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
Highlight the advantages of PPI(Partition Primary Index).
What do you mean by fastexport in teradata?
What are default access rights in teradata? What explicit right can be given to a user?
Highlight the differences between Primary Key and Primary Index.
What is bteq script in teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
if collect stats but it show low confidence why?
What is logical data model?
What is dimensional modeling?
Highlight the need for Performance Tuning.
What are some commonly used bteq scripts?
In general, how do you optimze any sql in teradata?
What are the different table types supported by teradata?
What is upsert statement in teradata?
If RDBMS is halted what will you do ?