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...

  1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



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

Answer / mohan

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

Is This Answer Correct ?    5 Yes 0 No

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

Answer / vimal

We can use minus query and intersect query

unmatched: records in a but not in b
select *
from a
minus
select *
from b ;

matched: recrods in a and in b
select *
from a
intersect
select *
from b ;

Is This Answer Correct ?    4 Yes 1 No

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

Answer / 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

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

Answer / 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

More Teradata Interview Questions

What are the functions performed by bynet?

0 Answers  

Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???

1 Answers   IBM,

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

0 Answers   IBM,

Can we collect statistics on multiple columns?

0 Answers  

What are the different table types that are supported by teradata?

0 Answers  

I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.

13 Answers  

What do you mean by caching in teradata?

0 Answers  

What are the advantages of teradata?

0 Answers  

What type of indexing mechanism do we need to use for a typical data warehouse?

0 Answers  

What are the things to be considered while creating secondary index?

0 Answers  

Why Multiload does not supports USI and supports NUSI?

4 Answers  

What is meant by MATCHTAG in multiload utility?

2 Answers   Satyam,

For more Teradata Interview Questions Click Here
Categories