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

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

1001


What happens when a node suffers a downfall?

1130


Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

2048


What interface is used to connect to windows based applications?

1113


What are the functions of a Parser?

1113


How many types of joins are there in teradata?

976


How to load specific no.of records using bteq, or fastload,or multiload

1747


How to identify ppi columns?

1178


What are some commonly used bteq scripts?

1009


What is the opening step in basic teradata query script?

1037


How is MLOAD Client System restarted after execution?

1153


What is teradata? What are some primary characteristics of teradata?

974


Explain the types of join supports by teradata?

994


how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1737


What are the available join types in teradata?

1066