delete from table (table name.a) where rowid not in(select min(rowid) from

Write an SQL Query to
Delete Duplicate records from a table using ROWID.

Question Posted / venki_discussions

24 Answers
77952 Views
pspl, Satyam, Thinkways, I also Faced
E-Mail Answers

Answer Posted / venki_discussions

delete from table (table name.a) where
rowid not in(select min(rowid) from (table name.b)
group by (column name);

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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

2425

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?

1069

How do you register report in oracle apps?

1100

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2223

What is oracle soa suite and what are its different components?

1223

Can we create tables in apps schema?

1148

what are the balancing segments in AR?

2103

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2634

How many schemas we have? how many you have used?

2069

is it possible to run the interface without using oracle apps?

1986

What does appl_top directory contain?

1133

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

2083

what is the difference between request group and request security in oracle apps?

5907

Is soa a part of oracle fusion middleware?

1097

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2619