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
What is meant by a node?
if collect stats but it show low confidence why?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What are the different design perspectives used in teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
Which is faster fastload or multiload?
Define views in teradata with syntax.
What is the purpose of using case expression in teradata?
Explain teradata architecture in detail with a diagram.
What are the various etl tools in the market?
Explain teradata vs. Redshift?
any one answer me how they can analyzing the project using data ware housing?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is bteq script in teradata?
How do you verify a complicated sql?