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

Explain fallback in teradata?

597


How many sessions of MAX is PE capable of handling at a particular time?

587


What are the components used in smp and massively parallel processing (mpp) machines?

588


i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

1761


What is the purpose of joins in teradata?

533






What are some primary characteristics of teradata?

540


How do you set the session mode parameters in bteq?

597


What happens when a node suffers a downfall?

663


When tpump is used instead of multiload?

620


How teradata makes sure that there are no duplicate rows being inserted when its a set table?

551


What do you mean by teradata intelliflex?

620


What is primary index and secondary index?

561


What are the available join types in teradata?

588


Did you write stored procedures in teradata?

609


Explain the term 'row' related to relational database management system?

523