delete from emp where rowid not in ( select max(rowid) from emp group by

write a query to delete similar records in particular
fields(columns) in different tables

Question Posted / khandu shinde

Answer Posted / khandu shinde

delete from emp where rowid not in ( select max(rowid) from
emp group by empno)

Is This Answer Correct ?

7 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What sql does db2 use?

544

How do I view stored procedures?

545

Can we call procedure in select statement?

521

Define commit, rollback and savepoint?

580

What is cross join sql?

504

How many scalar data types are supported in pl/sql?

526

What is memory optimized table?

577

How to handle bulk data?

893

Why do we use triggers?

522

how to fetch alternate records from a table? : Sql dba

605

what is the difference between truncate and delete statement? : Transact sql

552

what is index? : Sql dba

558

What is join view in sql?

515

What are tuples in sql?

571

Can you join views in sql?

544