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

What is ASM (Automatic Storage Management) in Oracle?

1196

How to rename a column in an existing table?

1035

What is using clause and give example?

1038

Is rowid unique in oracle?

998

What is a cursor variable?

1127

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3050

How to update a table row with a record?

1008

How to delete an existing row from a table in oracle?

1070

Which environment variables are absolutely critical in order to run the OUI?

2118

What is a data lock in oracle?

1118

Can you drop an index associated with a unique or primary key constraint?

1019

What is not equal to in oracle?

1001

What are the different editions of oracle?

1106

State any two functions of oracle?

1045

What is set operator oracle?

978