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
- 16253 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 does data normalization mean?
Define the select into statement.
What is an invalid partition table?
Is sqlite thread safe?
What is the difference between having and a where in sql?
How to place comments in pl/sql?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What is date functions?
Can we use having without group by in sql?
List out the acid properties and explain?
Can pl sql procedure have a return statement?
What is the maximum number of triggers, you can apply on a single table?
Is nosql faster than sql?
What is the purpose of cursors in pl/sql?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
