delete from
(
select s_orgcode,s_payeeacct,row_number() over(partition by s_orgcode,s_payeeacct) as row_num from TS_SPECACCTINFO) a where row_num > 1
delete from
(
select s_orgcode,s_payeeacct,row_number() over(partition by s_orgcode,s_payeeacct) as row_num from TS_SPECACCTINFO) a where row_num > 1