delete from table name where rowid not in(select max(rowid) from table nam

I have table-A(1,2,3,4,4,5,6,6,6,7).
how to get all duplicate values?what is sql query?

Question Posted / a.brahmam

Answer Posted / a.brahmam

delete from table name
where rowid not in(select max(rowid) from table name group by column name)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Difference between inner join vs where ?

1096

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5478

What is an oracle cursor variable?

1133

How to change user password in oracle?

1099

How to use subqueries with the in operator using oracle?

1139

what are the default admin accounts in Oracle 10g ?

1024

How can I introduce multiple conditions in like operator?

1051

How do I connect to oracle database?

1198

How to create a new user account in oracle?

1065

various types of hints and their usage

2751

How to select some columns from a table in oracle?

1175

How to install oracle odbc drivers?

1145

How to upsert (update or insert into a table)?

1044

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2266

What is Undo Management Advisor in Oracle?

1154