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

How do you run a query?

979

what happens if you no create privilege in a database? : Sql dba

981

Write the command to remove all players named sachin from the players table.

1159

How do you define a foreign key?

978

Is a secondary key the same as a foreign key?

1012

Explain locks? : Transact sql

985

What are the rules to be applied to nulls whilst doing comparisons?

1307

what is table? : Sql dba

1040

What is a schema sql?

1122

What is normalisation and its types?

988

What is difference sql and mysql?

966

What is the difference between the conventional and direct path loads? : aql loader

1374

What is a sql schema used for?

1076

Why we use triggers in mysql?

978

Does sql view stored data?

936