Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 joins in teradata?

1016


What happens when a node suffers a downfall?

1135


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

1103


How many tables can you join in v2r5?

1073


In BTEQ, how are the session-mode parameters being set?

1143


What is teradata? What are some primary characteristics of teradata?

974


what is sysdba and sysdbc ? which has high priority ?

3831


How will you solve the problem that occurs during update?

1057


How to identify ppi columns?

1182


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3625


Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

1043


Explain teradata utilities?

1044


Syntax for case when statement?

1069


What is the basic syntax for teradata select statement?

1049


What do you mean by fastexport in teradata?

1006