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
15997 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

What is the difference between a primary key and a unique key?

997

What is coalesce sql?

939

What is pragma in sql?

1020

Is full outer join same as cross join?

912

Is the primary key an index?

981

Explain what is a field in a database and record in a database?

1014

how to drop an existing table in mysql? : Sql dba

981

What is nvl?

1018

Can we use pl sql in sql server?

1010

How do I remove duplicates in two columns?

974

How many types of cursors are available in pl/sql?

1041

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

967

what is log shipping? : Sql dba

1055

What is an index in sql with example?

918

how to delete an existing column in a table? : Sql dba

950