i think..By using joins we can get required records.based on your requirem

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

Question Posted / gowthami

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

Please Help Members By Posting Answers For Below Questions

What is basic teradata query language?

1089

What are normalization, first normal form, second normal form and third normal form?

1037

What are the commands to make a new table, change a table and remove a table in teradata?

1113

Explain the new features of teradata?

1024

During the Display time, how is the sequence generated by Teradata?

1036

In Teradata, how do we Generate Sequence?

1028

List the logical and conditional operators that are used with teradata along with their meanings?

981

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

813

How to eliminate product joins in a teradata sql query?

998

How to view every column and the columns contained in indexes in teradata?

1026

how can we analyze the locks ?

2109

What is a level of granularity of a fact table?

1133

Highlight the limitations of TPUMP Utility.

1096

What are the functions performed by bynet?

1030

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1083