delete from tablename a where rowid not in(select max(rowid) from tablenam

how to eliminate duplictes in column except group and
section?

Question Posted / jagan

Answer Posted / jagan

delete from tablename a where rowid not in(select max(rowid)
from tablename b where a.rowid=b.rowid)

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is responsibility and how u attach How to create user and how u attach with responsibility.

2041

Is it possible to execute a dynamic sql from forms?

1073

if u want to delete all these detail block etc what will happen in form

1989

What do we mean by record group in oracle forms?

1076

What is the difference between bind and lexical parameter?

1079

What is a matrix report and how many minimum groups are required to prepare the same?

1143

what is tripstop report?

1835

Why oracle forms required?

1044

What is the difference between flex mode and confined mode?

1052

a text item is there what r the different types of triggers associated with it

2016

How to create Drill down report?

2128

What do you understand by oracle forms?

1044

can you convert or reverse engineer a fmx back to a fmb file?

1164

what is the difference between call_form, new_form and open_form?

1309

difference between global n context sensitive segments?

2677