表数据如下:
删除字段IosVersion 相同的数据,保留id最小的一条
方法1:sql如下:
方法2: 采用distinct函数
delete from AppVersion where IosVersion in( select distinct IosVersion from AppVersion )
and Id not in (select min(Id) from AppVersion where IosVersion in (select distinct IosVersion from AppVersion))