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
16255 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 the difference between microsoft access and sql?

1012

Which is faster subquery or join?

1206

What are the different types of constraints?

1169

How do you rename a table in sql?

1101

how to get a list of all tables in a database? : Sql dba

971

What is a record in pl/sql?

1138

What is rtm in testing?

1101

Is primary key always clustered index?

1013

Is primary key an index?

989

How to call shell script from pl sql procedure?

1270

How is indexing done in search engines?

980

what are rollup and cube in t-sql? : Transact sql

1092

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1222

What is date functions?

1024

what is rdbms? : Sql dba

1010