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

Can we insert data in view oracle?

535

how can we store any pdf file in oracle

1642

What are the original export and import utilities?

569

What is a data dictionary and how can it be created?

615

Which are the five query types available in oracle?

530

How to recover a dropped table in oracle?

605

Explain how are indexes update?

623

How to start instance with a minimal initialization parameter file?

535

How to name query output columns in oracle?

686

In what script is snap$ created? In what script is the scott/tiger schema created?

2245

what is the dual table in oracle?

553

What is bulk collect in oracle?

551

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

1848

How to do clean up if create database failed?

576

What do you mean by merge in oracle?

591