 |
| Total Answers and Comments: 3 |
Last Update: December 04, 2006 Asked by: myquery |
|
| | |
|
No best answer available. Please pick the good answer available or submit your answer. | |
March 16, 2006 08:43:16 | #1 |
| Abhishek Gupta |
|
|
RE: how to delete set of records at a time where all t...
| yes you can delete the duplicate records with the help of a sql query as follows delete from table_name where rowid not in(select max(rowid) from table_name group by field_name) in this way only rowid with distinct values will remain and the rest will be removed.I hope it will help you out.
| | | Is this answer useful? Yes | No | | |
|
| |
|
December 04, 2006 14:14:24 | #3 |
| rampratap409 |
|
Member Since: September 2006 Contribution: 111 |
RE: how to delete set of records at a time where all t...
| use this query: delete from emp e where rowid <> ( select max(rowid) from emp where ename e.ename );
| | | Is this answer useful? Yes | No | | |
|
| |
Go To Top
|
