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
- 14462 Views
- CGCI, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to pronounce postgresql?
What is rank function in sql?
how many triggers are allowed in mysql table? : Sql dba
What steps server process has to take to execute an update statement?
How can a pl sql block be executed?
Why having clause is used in sql?
How insert into statements in sql?
Explain what is an index?
What is sql character function?
What is difference between function and trigger?
Explain the structure of pl/sql in brief.
How many row comparison operators are used while working with a subquery?
What are the two types of exceptions in pl/sql?
What are the qualities of 2nf?
What is a database? Explain
