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

Answer Posted / mohan

full outer join can be used to get both unmatched and
matched records..

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between global temporary tables and volatile temporary tables?

641


what are the day to day activities of teradata DBA ?

5376


What is basic teradata query language?

644


How can we check the version of Teradata that we are using currently?

598


What is the use of stored procedures in teradata?

570






What is meant by Teradata Gateway?

586


List out all forms of LOCKS that are available in Teradata.

560


Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

1611


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

552


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

579


In Teradata, how do we Generate Sequence?

611


Highlight the points of differences between the database and user in Teradata.

595


What exactly do you know about catching in teradata?

645


What is meant by a Channel Driver?

653


what is object level locking ? where do appear this type of locking ?

3118