informix数据去重
假设test表以fd1,fd2字段为唯一元素
select b.rowid id from test a , test b where a.fd1=b.fd1 and a.fd2=b.fd2 and a.rowid<>b.rowid and a.rowid in (select min(rowid) from test group by fd1,fd2) into temp rmrow;
delete from test where rowid in (select id from rmrow);