delete from tablename a where a.rowid>(select min(rowid) from tablenam

Delete duplicate records in the emp table.

Question Posted / smriti

Answer Posted / smriti

delete from tablename a where a.rowid>(select min(rowid)
from tablename b where a.columnname=b.columnname)

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1000

discuss about myisam key cache. : Sql dba

1019

What is a dirty read sql?

1131

What is execute immediate?

1081

How do we use distinct statement? What is its use?

1029

What is transaction control language (tcl)?

1133

What is sql keyword?

997

What is the use of function in sql?

1090

define sql update statement ? : Sql dba

1114

what is union? : Sql dba

1025

How many clustered indexes can you have?

973

How to check if a column is nullable before setting to nullable?

1122

Which operator is used in query for pattern matching?

1087

What are the uses of sysdate and user keywords?

1100

What is sql*loader and what is it used for?

1147