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

How do we accept inputs from user during runtime?

1116

What do you mean by stored procedures? How do we use it?

1035

What does a pl/sql package consist of?

1013

What is group by in sql?

1124

What is over () in sql?

1011

Why we use triggers in mysql?

1035

How do you take the union of two tables in sql?

1026

Does truncate need commit?

1001

How do you sort in sql?

1065

Is left join inner or outer?

1055

What is pl/sql table? Why it is used?

1078

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1079

what is 'mysqlcheck'? : Sql dba

1063

How do you create an update query?

1018

Compare sql & pl/sql

1208