delete afrom 数据_1 awhere exists( select * from 数据_1 b where b.[会员名]=a.[会员名] and b.[创建时间]=a.[创建时间] and b.[状态]<>a.[状态]) and a.[状态]='否'
