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 is query execution plan in sql?

571

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

692

how to shut down the server with 'mysqladmin'? : Sql dba

549

What is a natural join sql?

515

what is recursive stored procedure? : Sql dba

529

What are different types of statements supported by sql?

611

what are tables and fields? : Sql dba

584

What does where 1/2 mean in sql?

540

What is multiple columns?

576

how to create a new view in mysql? : Sql dba

502

how to get a list of all tables in a database? : Sql dba

513

What is data manipulation language?

702

what is msql? : Sql dba

570

Sql technical questions

779

what is the difference between join and union? : Sql dba

552