删除重复数据
delete from T_HR_YVBalance a
where fyear = '2013'
and rowid > (select min(rowid)
from T_HR_YVBalance b
where a.fpersonid = b.fpersonid
and fyear = '2013');
查看重复数据
select * from T_HR_YVBalance
where fpersonid in (select fpersonid
from T_HR_YVBalance
where fyear = '2013'
group by fpersonid
having count(fpersonid) > 1)