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
- 16251 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
What is assignment operator in pl sql?
What is bind variable in pl sql?
what is text? : Sql dba
how to run 'mysql' commands from a batch file? : Sql dba
What is the syntax to add a record to a table?
What is the use of index in hive?
What is right join sql?
What is the difference between join and natural join?
What are two statement types in sql?
What are the most important ddl statements in sql?
what is an alias command? : Sql dba
Can we group by two columns in sql?
Where not exists in sql?
What is a function in oracle pl sql?
Can we use view in stored procedure?
