delete from emp where rowid>any(select min(rowid) from emp a where a.

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 / dinesh mohan upadhyay

Answer Posted / dinesh mohan upadhyay

delete from emp
where rowid>any(select min(rowid) from emp a where
a.col1=col1)

Is This Answer Correct ?

15 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What is sqlerrd?

971

what are the differences between char and nchar? : Sql dba

1119

What are procedures used for?

991

How does cross join work in sql?

1023

what are date and time data types in mysql? : Sql dba

978

Explain mutating table error.

1213

How do you remove duplicates without using distinct in sql?

985

List the various privileges that a user can grant to another user?

1047

Can we join more than 2 tables in sql?

1028

What is assignment operator in pl sql?

1043

what are ddl statements in mysql? : Sql dba

1209

What is a stored procedure in sql with example?

1138

What are the different types of constraints?

1192

What are stored procedures used for?

1005

Are stored procedures faster than queries?

949