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 an SQL Query to
Delete Duplicate records from a table using ROWID.

Answer Posted / ravi kant yadav

Delete from table_name where ROWID not in ( select
max(rowid) from table group by duplicate_values_field_name);

Regards
ravi

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

1030


How can a process be deployed in soa?

1171


What is sca and how is it useful?

1063


Do you know what are user profiles in apps. Any examples you can give?

1053


Which oracle apps version you are very confident in?

1183


tell me the scenarios of the independent in reports

2567


testing tools?

2190


Can you explain the difference between architecture followed in 10g & 11g?

1023


where to define interorganization transaction charges and what are the different options?

2374


Can you define an erp system?

1102


In sequence i want to 11 and 15th values how we will write?

2029


q)what are the validations in sql*loader

2341


Is soa a part of oracle fusion middleware?

1042


List the types of flexfield?

998


Do you know where we can check the status of po?

1202