DELETE FROM EMP WHERE EMPID= 5 AND ROWNUM

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 / ajit

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

Answer Posted / ajit

DELETE FROM EMP WHERE EMPID= 5 AND ROWNUM < 2;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the difference between rename and alias?

1063

Difference between truncate, delete and drop commands?

1141

What is inner join in sql?

1133

How is sql used in oracle?

1037

what's the difference between a primary key and a unique key? : Sql dba

1105

How do you copy a table in sql?

1109

What is the best free sql database?

1101

what are the differences among rownum, rank and dense_rank? : Sql dba

1085

What is sql and db2?

1051

What does subquery mean in sql?

1112

What is the difference between microsoft access and sql server?

1104

What is the use of prepared statement?

1071

What is sql injection owasp?

1113

What is sql engine in oracle?

1038

What is pessimistic concurrency control? : Transact sql

1132