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 | 3 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 |
what is a database? : Sql dba
Can we enter data in a table in design view?
What are the different ways to optimize a sql query?
hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : chayabs3@gmail.com thnx advance
how do you login to mysql using unix shell? : Sql dba
what are the 'mysql' command line options? : Sql dba
can a stored procedure call itself or recursive stored procedure? : Sql dba
how to retrieve only duplicate values in a table
Can we debug stored procedure?
Is ms sql traffic encrypted?
what is the difference between pragma exception_init and raise_application_error
1 Answers Aetins, State Street,
What is spool?