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
- 8 Answers
- 13950 Views
- CGCI, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is “go” in t-sql? : Transact sql
How do I start sql profiler?
Is sql better than excel?
What is partition by in sql?
What is program debugging?
What is the difference between nested table and varray?
How can I get the number of records affected by a stored procedure?
Is it possible to link two groups inside a cross products after the cross products group has been created?
Explain alias in sql?
How to check if a column is nullable before setting to nullable?
Which command is used to delete a trigger?
How many types of functions are there in sql?
how can we submit a form without a submit button? : Sql dba
What is cost in sql execution plan?
explain the difference between delete , truncate and drop commands? : Sql dba
