delete t1 from futures t1
where exists(
select 1
from futures t2
where t1.Code = t2.Code and t1.date = t2.date and t1.volume<t2.volume
group by Code,date
)
--在 table futures中,删除字段code、date相同,当时字段volume值较小的行
SQL删除部分字段重复
最新推荐文章于 2022-09-07 11:23:26 发布