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

What are some primary characteristics of teradata?

1050


How is MLOAD Teradata Server restarted after execution?

1340


How do you verify a complicated sql?

1113


What is a node in teradata? Explain

1053


What is oltp?

1013


What are the frequently used data types in teradata?

1131


What is the use of fallback?

1036


What do you mean by teradata intelliflex?

1167


Discuss the advantages of using partitioned primary index in a query?

999


What are the steps involved in the process flow of the sql statement through channel attached system?

1160


What is partitioned primary index (ppi)?

1086


What is basic teradata query language?

1163


Difference between multiload and tpump?

1157


What is the use of teradata system software?

1087


A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

1344