delete from emp x where rowid>(select min(rowid) from emp where rmpno=x

Delete duplicate records in the emp table.

Question Posted / amedela chandra sekhar

Answer Posted / amedela chandra sekhar

delete from emp x where rowid>(select min(rowid) from emp
where rmpno=x.empno);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you update a table in sql?

993

What schema means?

893

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1197

How do you know if a relationship is 2nf?

950

What is the syntax to add a record to a table?

1092

how to write date and time literals? : Sql dba

970

What is informix sql?

985

What are predefined functions in sql?

1051

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1127

What are different categories of sql commands?

1135

How many sql statements are used? Define them.

1045

How to pronounce postgresql?

1065

What are character functions?

1092

Can we use two order by clause in query?

970

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

978