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 application trigger?

1050

How much does a sql dba make? : SQL DBA

983

Is sql a backend language?

1143

What is sql lookup?

967

Write a sql query to find the names of employees that begin with ‘a’?

1055

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

1105

Is inner join same as self join?

1163

What is composite data type in pl sql?

1165

Can we rename a column in the output of sql query?

1038

What are instead of triggers?

1099

What is a .db file?

1039

How can you select unique records from a table?

1144

Can we join tables without foreign key?

1003

Difference between global and parameter variables?

2009

Does google use sql?

1002