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 get maxsal , minsal, ename department wise in single query

1552

List the parts of a database trigger.

1053

Compare and contrast between sql and sql server and explain its various functions?

970

How to turn on or off recycle bin for the instance?

1085

Name the various constraints used in oracle?

1023

Please explain joins in oracle?

1066

What are the data types in oracle?

1044

What are the original export and import utilities?

1177

How to delete all rows a table in oracle?

1072

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1034

How do I reset a sequence in oracle?

1106

How do you find current date and time in oracle?

1050

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1935

What is a package ? What are the advantages of package ?

1093

What happens if you use a wrong connect identifier?

1069