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 normalization sql?

997

What is a call statement? Explain with an example.

954

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

907

what is the difference between nested subquery and correlated subquery?

988

What is string data type in sql?

1055

What is spool?

993

What is native sql query?

972

what is user defined functions? : Sql dba

977

What is an implicit commit?

996

What are different types of keys?

1020

How would you reference column values before and after you have inserted and deleted triggers?

1022

What is primary key in db?

936

What is flag in sql?

985

What is user in sql?

970

How can we make an if statement within a select statement?

959