Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in particular
fields(columns) in different tables
- 6 Answers
- 14157 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / satyam kumar
Hi,
I have manipulated Khandu Shinde answer because it will
delete complete row.
delete from emp where rowid not in ( select max(rowid) from
emp group by empno having count(redundantcolumnName) > 1)
Note: work only with Oracle.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What does the file extension accdb stand for?
What is pessimistic concurrency control? : Transact sql
How many unique keys can a table have?
What are the most important characteristics of pl/sql?
What is difference between my sql and sql?
What are the different dml commands in sql?
How can I change database name in sql?
What is union and union all keyword in sql?
what are the different type of sql's statements ? : Sql dba
Can you inner join the same table?
Why is pl sql used?
Explian rowid, rownum? What are the psoducolumns we have?
What is identity column in sql server?
Why use subqueries instead of joins?
Why is sql better than hql?
