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
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Answer / guest
u can delete by slelcting the rowid of that particular
record
Is This Answer Correct ? | 3 Yes | 4 No |
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 |
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 |
Explain the uses of a database trigger?
What is view explain with example?
What does sign mean sql?
What is pl sql collection?
What is sql query optimization?
What is string join?
Can variables be used in sql statements?
What is a field in a database?
What is the basic difference between a sql and stored procedure ?
How can you select unique records from a table?
How do I remove duplicates in two columns?
what is the difference between truncate and drop statements? : Sql dba