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 is %s in sql?

753

What is partition by in sql?

783

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

720

What is the use of function "module procedure" in pl/sql?

884

what is the difference between char and varchar data types? : Sql dba

741

What is before trigger?

735

How to get list of all tables from a database?

842

What type of database is sql?

774

Which is better varchar or nvarchar?

732

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

782

What is transaction control language (tcl)?

849

How do I view a sql database?

749

When are we going to use truncate and delete?

715

What is the maximum size of sqlite database?

726

What is pl/sql language case sensitive?

828