DELETE FROM EMP E1 WHERE ROWID <(SELECT MAX(ROWID) FROM EMP E2 WHERE E1

write a query to delete similar records in same table

Question Posted / raj

Answer Posted / raj

DELETE FROM EMP E1
WHERE ROWID <(SELECT MAX(ROWID) FROM EMP E2 WHERE E1.ENO =
E2.ENO)

Is This Answer Correct ?

25 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Is sql harder than python?

593

how do you know if your mysql server is alive? : Sql dba

578

what is a materialized view? : Sql dba

556

What do you understand by pl/sql records?

520

What are operators available in sql?

570

Will truncate release space?

508

What is the difference between python and sql?

511

What is the difference between distinct and unique in sql?

462

What is sql profiler in oracle?

546

Can we use having without group by in sql?

535

What does truncate mean in sql?

526

What is numeric function sql?

529

Explain the purpose of %type and %rowtype data types with the example?

539

Which tcp/ip port does sql server run?

518

What is the difference between a primary key and a clustered index?

511