1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / g.sathyanarayanan

Answers were Sorted based on User's Feedback



How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for ..

Answer / akshita

delete from emp where rowid not in (select max(rowid) from
emp group by empno)

Is This Answer Correct ?    11 Yes 2 No

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for ..

Answer / mail2sentha

DELETE FROM EMP WHERE ROWID NOT IN(SELECT MIN(ROWID)FROM
EMP GROUP BY EMPID);

Is This Answer Correct ?    6 Yes 0 No

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for ..

Answer / rohit kumar

Delete from employee where (empid,empname) notin (select min
(empid),empname from employee group by enmpname);

Is This Answer Correct ?    2 Yes 1 No

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for ..

Answer / ajit

DELETE FROM EMP WHERE EMPID= 5 AND ROWNUM < 2;

Is This Answer Correct ?    0 Yes 0 No

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for ..

Answer / guest

u can delete by slelcting the rowid of that particular
record

Is This Answer Correct ?    3 Yes 4 No

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for ..

Answer / his highness yadav

ur question is not much clear

is it to delete duplicate rows or

to delete all the rows which is repeating , and the original

fr the first the query above will work fine

second option try this

delete from emp a, emp b where a.empno=b.empno

i think this will go ,, this will delete the all records which
is duplicating


cheers

Is This Answer Correct ?    1 Yes 4 No

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for ..

Answer / 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

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for ..

Answer / vijay

Delete from emp where empid=5;

Is This Answer Correct ?    4 Yes 10 No

Post New Answer

More SQL PLSQL Interview Questions

What do you mean by table in sql?

0 Answers  

What is set serveroutput on?

0 Answers  

What does t sql mean?

0 Answers  

what is outer join? what is selef join? what is difference between them? what is cartecion join?

1 Answers   Fiserv, Herbinger, Synechron,

What is a temp table?

0 Answers  




How many types of database triggers can be specified on a table ? What are they ?

2 Answers  

What is the diffrence between IN and EXISTS.which one is faster.

3 Answers   Infogain,

what are date and time data types? : Sql dba

0 Answers  

How many types of cursors supported in pl/sql?

0 Answers  

What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

What is record type in pl sql?

0 Answers  

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories