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
16302 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 is column?

991

Is natural join same as inner join?

940

What is cursor in pl sql with examples?

1033

How to rename a column in the output of sql query?

1072

how to see the create table statement of an existing table? : Sql dba

1016

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7347

Is ms sql is free?

1020

What is pl sql record in oracle?

1035

What is difference between function and trigger?

1048

what is the difference between union and union all? : Sql dba

1020

What is example of database?

1056

What is the need of merge statement?

1038

What are types of exception?

922

how to escape special characters in sql statements? : Sql dba

1035

What are the types of functions in sql?

1019