delete from table_name where rowid not in(select min(rowid) from table

write a query to delete similar records in same table

Question Posted / nirmalendu

Answer Posted / nirmalendu

delete from table_name where rowid not in(select min(rowid)
from table_name group by column_name);

** column_name which having duplicate record

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is cursor. write example of it. What are the attributes of cursor.

1392

Can we use having without group by in sql?

983

What is t sql used for?

1015

What is normalisation in sql?

1057

What does cursor do in sql?

1025

when is the use of update_statistics command? : Sql dba

1049

What language is oracle sql developer?

1020

Is left join faster than inner join?

1125

Which is better join or inner query?

1049

What are the different dml commands in sql?

1176

What is multiple columns?

1069

what is the command line end user interface - mysql? : Sql dba

982

What is view? Can we update view

1440

how to drop an existing view in mysql? : Sql dba

1061

What are all the ddl commands?

1184