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
- 14922 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
How exception is different from error?
Why we use sql profiler?
What are the most important ddl statements in sql?
What is serial sql?
Which is faster view or stored procedure?
Define commit?
define join and explain different type of joins? : Sql dba
what is self-join? : Sql dba
What is trigger point?
how to calculate expressions with sql statements? : Sql dba
What is set transaction?
Does sql*plus have a pl/sql engine?
what is oltp (online transaction processing)? : Sql dba
What is varchar used for?
What is normalization in sql?
