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

How to connect the oracle server as sysdba?

1063

How remove data files before opening a database?

1049

How to resolve name conflicts between variables and columns?

1004

What is the fastest query method to fetch data from the table?

1343

What is meant by raw datatype?

1045

What is an Oracle Instance?

1105

What happens in oracle commit?

1002

What are the different types of database objects?

1042

What is the difference between pre-select and pre-query?

1190

What happens to the data files if a tablespace is dropped?

1041

What is the usage of synonyms?

1118

Why does oracle 9i treat an empty string as null?

1034

How to lock and unlock a user account in oracle?

1082

How do I recompile a procedure in oracle?

948

Â How to use an oracle sequence generator in a mapping?

1053