delete from emp p where rowid<(select max(rowid) from emps where p.ename

how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used

Question Posted / venkateswararao

Answer Posted / venkateswararao

delete from emp p where rowid<(select max(rowid) from emps where p.ename=s.ename)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is table? : Sql dba

984

Is delete faster than truncate?

954

How do I view a procedure in sql?

906

What does desc stand for?

1021

What is pl sql commands?

979

How does one use sql*loader to load images, sound clips and documents? : aql loader

1117

How do you update f as m and m as f from the below table testtable?

1787

how do you know if your mysql server is alive? : Sql dba

1024

how to check server status with 'mysqladmin'? : Sql dba

1010

What is mdf ldf and ndf?

929

Is sqlexception checked or unchecked?

917

Why is normalization important?

968

What is the difference between sum and count in sql?

936

what is column? : Sql dba

956

describe transaction-safe table types in mysql : sql dba

943