Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 16323 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 can we make an if statement within a select statement?
What do you mean by “trigger” in sql?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is sql indexing?
What is mutating table error?
What is the difference between inner join and outer join?
Can a table contain multiple foreign key’s?
How do you use join?
how is myisam table stored? : Sql dba
How many types of indexes are there in sql?
What is the purpose of cursors in pl/sql?
Is json a nosql?
How can you save or place your msg in a table?
How do I run sql profiler?
how are mysql timestamps seen to a user? : Sql dba
