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 to delete duplicates records in teradata without any
tables....?
with only one single query,,,?

Answer Posted / jain

DELETE FROM table_name A WHERE ROWID > (SELECT min(rowid)
FROM table_name B WHERE A.key_values = B.key_values)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is code review?

1123


What is software fault?

1086


Metrics of your Project?

2176


what is cohensive testing and span control?

2512


What is equivalence partitioning testing?

1064


What is applications of FCOE?

2635


what is the main purpose of informal review

1428


What is the main goal of defect prevention meeting?

1066


i am fresher in manual testing.how to do database testing as a manual tester.suggest me some answers,so that i will have a clear idea adout database testing.

2385


What are the main constrains of SCSI in storage networking?

1903


What is test result analyzer?

1256


i am a PG science(chemistry),now am working test engineer in small organization,now i will decide to move better organization please send model cv and advises

2279


Test report?

1016


Testing activity which is performed to expose defects in the interfaces and in the interaction between integrated components is?

1128


What is process and procedures?

1065