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

What is rename command in sql?

463

What is a record in a database?

559

How do you sort in sql?

600

What is difference between procedure and trigger?

512

What does the sign mean in sql?

505

What is the largest value that can be stored in a byte data field?

518

Is there a way to automate sql execution from the command-line, batch job or shell script?

555

What is the difference between instead of trigger and after trigger?

510

What is pl sql architecture?

500

Is it important to partition hard disk?

532

What is sharding in sql?

564

What jobs use sql?

526

Can primary key be changed?

527

How to connect a sql*plus session to an oracle server?

619

Explain the uses of control file.

613