Hi, You can use the below mentioned query .... SELECT ROWID( 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 / prajyot

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

Answer Posted / prajyot

Hi,

You can use the below mentioned query ....

SELECT ROWID( Emp_id ) FROM EMP WHERE Emp_id = 5;

Praj

Is This Answer Correct ?

1 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are tables and fields?

1027

How can I speed up sql query?

954

what is a control file ? : Sql dba

1027

what are the advantages of sql ? : Sql dba

1052

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1091

What is primary key in db?

1001

How do temporal tables work?

951

what is a cursor? : Sql dba

1017

What is difference between mysql and postgresql?

1138

Is foreign key mandatory?

998

What normalization means?

963

What do you understand by pl/sql packages?

1058

How is a PL/SQL code compiled?

1218

What is a record in a database?

1055

What does truncate mean in sql?

1017