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 eexception?

1115


What are test comparators?

1034


Explain inputs?

995


how to attach and detach databases in sql?

2075


What is cause-effect graphing?

1040


Examples where you have worked on your own and as part of a team.

2227


What is test driver?

1196


What is storage virtualization?

2062


How many effort estimation methods available in market for testing?

1002


What are validation and verification?

1119


What is independent test group (itg)?

1302


During the testing of a module tester, 'x' found a bug and assigned it to a developer. But developer rejects the same, saying that it's not a bug. What 'x' should do?

1253


Faults found should be originally documented by whom?

1402


What is the main goal of defect prevention meeting?

1068


I Want To Join Infrasoft Technologies,what is the Procedure To Join The Company?

2890