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

5 Answers
8382 Views
Zensar, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the different oracle database objects?

1030

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

5330

Can we create database in oracle using command line ?

1028

How to estimate disk space needed for an export job?

990

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2198

Describe the types of sub query?

938

How to use attributes of the implicit cursor in oracle?

947

What is java oracle used for?

965

What is the sql query to concatenate column values from multiple rows in oracle?

996

What is a directory object?

1023

What is the difference between PFILE and SPFILE in Oracle?

994

Name the various constraints used in oracle?

969

How do I uninstall oracle 11g?

1041

What is oracle thin client?

973

How to create a new oracle data file?

969