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
- 16574 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
Why is pl sql used?
Can unique keys be null?
How do I install sql?
Can we write ddl statements in functions?
what does the t-sql command ident_current does? : Transact sql
Can we use two order by clause in query?
Why stored procedure is better than query?
Can we use update in sql function?
What are different sql data types?
What are % type and % rowtype?
What are local and global Indexes and where they are useful.
Is primary key clustered or nonclustered?
how to convert character strings to numeric values? : Sql dba
What is union and union all keyword in sql and what are their differences?
How to run sql*plus commands in sql developer?
