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
16252 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 what is a view?

1054

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

1089

How to write pl sql program in mysql command prompt?

1088

What are the different dcl commands in sql?

1143

How many sql statements are used?

1006

How would you convert date into julian date format?

1000

How to call a javascript function from pl sql?

1129

What is use of package in pl sql?

1009

How global cursor can be declare with dynamic trigger ?

2202

What is the use of triggers?

1031

What is difference between sql and excel?

1081

Does sql view stored data?

949

Why schema is used in sql?

1044

What are basic techniques of indexing?

1380

What are all the different normalizations?

1025