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 meant by <> in sql?

499

What are the most important characteristics of pl/sql?

566

Does mysql_real_escape_string prevent sql injection?

533

what is denormalization. : Sql dba

538

Explain normalization and what are the advantages of it?

514

what are date and time functions in mysql? : Sql dba

528

what is acid property in database? : Sql dba

555

What is the use of double ampersand (&&) in sql queries? Give an example

600

How to avoid duplicate records in a query?

573

Can pl sql procedure have a return statement?

544

What language is oracle sql developer?

500

Are stored procedures compiled?

520

How many rows can sqlite handle?

576

how many groups of data types? : Sql dba

557

what is the difference between a local and a global temporary table? : Sql dba

545