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

Write a single SQL to delete duplicate records from the a
single table based on a column value. I need only Unique
records at the end of the Query.

Answer Posted / yuvaevergreen

Hi Vinay,
Thanks ya for the catch and appre...

Hi guys,
Please ignore the first approach using the delete statement. It is wrong.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how spool space is used.

1070


What are tpump utility limitations?

1118


If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2471


What interface is used to connect to windows based applications?

1108


what are the uses of fact table and dimension table in banking project?

4554


What exactly do you know about catching in teradata?

1034


Why teradata is used?

996


Describe the set operators in teradata.

1002


What is spool space?

1149


Why managing the data is important?

1013


What is meant by Teradata Gateway?

1057


Can you fastexport a field, which is primary key by putting equality on that key?

1173


Difference between multiload and tpump?

1094


What are the various indexes in teradata? How to use them? Why are they preferred?

1059


What is spool space? Why do you get spool space errors? How do trouble-shoot them?

982