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
16551 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 an alias command? : Sql dba

1164

Can sql function call stored procedure?

1067

What is fmtonly in sql?

1154

Which are sql * plus commands?

1195

What are the different types of triggers?

1185

How to run pl/sql statements in sql*plus?

1128

What is dense_rank?

984

How do I find duplicates in the same column?

1162

how many tables will create when we create table, what are they? : Sql dba

1110

What is on delete set null?

1132

Is record in oracle pl sql?

1011

What is case function?

1086

What is a design view?

972

What is the location of pre_defined_functions.

1203

What are the types of operators available in sql?

1115