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 are reports usually used for?

1017

What is clause?

1140

What is trigger explain it?

1008

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1057

What does where 1/2 mean in sql?

1061

What is the sql case statement?

987

What is a pdo connection?

1023

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1045

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

979

What is an example of translating a date into julian format?

1112

Explain the methods used to protect source code of pl/sql.

1012

what are enums used for in mysql? : Sql dba

1165

What is the use of sql trace?

947

What does count (*) mean?

925

How do I run a sql query in pgadmin 4?

958