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

How do I run a sql query in pgadmin 4?

918

What do you understand by case manipulation functions?

973

How many types of relationship are there?

991

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1228

How can a function retun more than one value in oracle with proper example?

1041

what is datawarehouse? : Sql dba

968

What are the possible values that can be stored in a boolean data field?

963

Describe different types of general function used in sql?

994

How can I tell if sql is running?

1011

What is pivot in sql?

882

Can function return multiple values in sql?

998

What are the possible values for the boolean data field?

916

what is difference between delete and truncate commands? : Sql dba

1078

What are the types of keys?

947

Can we use delete in merge statement?

1015