delete from tbndfuture
where rowid not in
(
select max(rowid) from tbndfuture group by i_code having count(*)>1
union
select max(rowid) from tbndfuture group by i_code having count(*)=1
)
2021-09-29 02:55:38
delete from tbndfuture
where rowid not in
(
select max(rowid) from tbndfuture group by i_code having count(*)>1
union
select max(rowid) from tbndfuture group by i_code having count(*)=1
)