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

How do you eliminate duplicates?

Answer Posted / guest

Let us consider table ‘B’ containing duplicates.


Create a empty table ‘A’ with set option and send the data
from table ‘B’ to table ‘A ‘so that only unique records will
be inserted. Now drop table ’B’ and rename table ‘A’ with
table ‘B’.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is inner join and outer join?

1037


Why managing the data is important?

953


Is multi insert ansi standard?

2142


Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1129


Why is the case expression used in teradata?

1021


What is spool space?

1069


What are different table types used in teradata?

979


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2361


What are the different functions included in the server software?

978


any one answer me how they can analyzing the project using data ware housing?

2407


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

971


What is teradata?

1056


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

938


What is upsert statement in teradata?

1051


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

1030