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 to use in conditions? : Sql dba

509

How to return an array from java to pl/sql?

587

What are inbuilt functions in sql?

595

explain the advantages and disadvantages of stored procedure? : Sql dba

531

How many types of indexes are there in sql?

535

How do you rename a table in sql?

532

What is sql server and ase?

538

what are date and time functions in mysql? : Sql dba

532

what is a foreign key ? : Sql dba

605

when MSQL8.0 is in market

1596

Could you please provide oca (oracle 10g) dumps for my certification ?

4508

What is scalar function?

566

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

735

What are the different types of database management systems?

530

Write a sql select query that only returns each name only once from a table?

565