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
- 16013 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 pl/sql table? Why it is used?
What is full join?
What is record type in pl sql?
What is exit statement?
What does stand for in sql?
What is left join in postgresql?
Is crud a cuss word?
How do you copy a table in sql?
what are aggregate and scalar functions? : Sql dba
What is the difference between microsoft sql and mysql?
Can we connect to postgresql using sql developer?
What is sql stand for?
What is the location of pre_defined_functions.
What has stored procedures in sql and how we can use it?
Why cross join is used?
