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

Explain character-manipulation functions?

1176

Why is sharding used?

1064

What is the difference between sql and t sql?

1107

What is the command used to fetch first 5 characters of the string?

1467

What port does sql server use?

1112

How many types of triggers are there in pl sql?

1120

Why are aggregate functions called so?

1012

Which command is used to delete a package?

1236

What is sorting in sql?

986

Explain about various levels of constraint.

1000

What is crud sql?

1031

Does postgresql run on the cloud?

1223

How can you create an empty table from an existing table?

1129

What is the difference between local and global temporary table?

1090

What is varchar used for?

1139