I want to write one query
How to get Matched records and unmatched records in table?

Answer Posted / gowthami

i think..By using joins we can get required records.based on
your requirements we should choose left outer join or right
outer join

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the uses of fact table and dimension table in banking project?

4090


What are the advantages of teradata?

592


What is logical data model?

630


A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

679


In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

567






What are the different design perspectives used in teradata?

540


Where is teradata rdbms used?

662


Highlight the advantages of PPI(Partition Primary Index).

557


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

1948


How to select first n records in teradata?

602


Which is more efficient group by or distinct to find duplicates?

632


How to run a query in teradata?

574


What are the different functions included in the server software?

594


if collect stats but it show low confidence why?

1178


What is the use of virtual processor connectivity in teradata?

559