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

How do you create a db file?

957

What are packages in pl sql and also explain its advantages?

959

Is json a nosql?

914

What is case function?

988

What is data type in sql?

919

What is the function that is used to transfer a pl/sql table log to a database table?

950

What are the rules to be applied to nulls whilst doing comparisons?

1273

what is a tablespace? : Sql dba

1004

What are the different operators available in sql?

960

Is pl sql a programming language?

924

What is the usage of nvl function?

982

What is schema in sql?

886

what is the difference between inner and outer join? Explain with example. : Sql dba

971

what is data manipulation language? : Sql dba

945

Why do we use set serveroutput on?

922