Re: How to write ?
Anjan Chakraborty wrote:
>
> Hello,
> How to write an SQL script which will find and delete the duplicate records
> ?
> Thanks.
> Anjan
Anjan,
assuming your table with the duplicate records is mytb issue following
SQL statements:
unload to "mytb.dat" select unique * from mytb;
delete from mytb;
load from "mytb.dat" insert into mytb;
Regards
Tolis
+---------------------------------------------------------------------+
| V+K Relational Solutions email: tvarnas@compulink.gr |
| Deligiorgi 26 tvarnas@orbit.de |
| 546 42 Thessaloniki Voice: (30) 31 820270 |
| Greece Fax: (30) 31 865463 |
+---------------------------------------------------------------------+