DELETE FROM EMP WHERE ROWID NOT IN(SELECT MIN(ROWID)FROM EMP GROUP BY EMP

How to delete same emp id in sql query for exmaple in emp
table emp id, empname, emp address. for example emp id =5,
repeated in two times in rows same id how to delete same
empid please any one of the write query send in my id

Question Posted / mail2sentha

8 Answers
16354 Views
CGCI, I also Faced
E-Mail Answers

Answer Posted / mail2sentha

DELETE FROM EMP WHERE ROWID NOT IN(SELECT MIN(ROWID)FROM
EMP GROUP BY EMPID);

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is native sql query?

1033

What are the basic sql commands?

1100

Does truncate remove indexes?

1042

how to select unique records from a table? : Sql dba

1121

What is sql query optimization?

1125

what is error ora-03113: end-of-file on communication channel?

1173

How to call a javascript function from pl sql?

1150

What is the use of index in sql?

1023

What is sap sql?

989

What is the difference between union and union all command?

1096

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

1083

Explain what is a view?

1070

What is trigger types of trigger?

1079

How many scalar data types are supported in pl/sql?

1069

Is truncate ddl or dml?

997