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

Why teradata is used?

1007


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

1003


How is MLOAD Teradata Server restarted after execution?

1267


What are the different softwares used with their functions in teradata?

1015


How can you track login parameters of users in teradata?

1196


What are the different design perspectives used in teradata?

983


Highlight the advantages of PPI(Partition Primary Index).

1078


What is the purpose of joins in teradata?

1190


How many tables can you join in v2r5?

1073


How you will check the version of teradata?

1168


Give the sizes of SMALLINT, BYTEINT and INTEGER.

1171


What is meant by a Least Cost Plan?

1060


What do you mean by teradata intelliflex?

1104


What is multi insert?

1052


Explain and compare pros and cons of snow flake schemas?

1035