sql语句实现删除一列中的重复数据,只留下一个
delete from midbatch where [订单编号] in (select [订单编号] from midbatch group by [订单编号] having count([订单编号]) > 1) and rowid not in (select min(rowid) from midbatch group by [订单编号] having count([订单编号] )>1)
要实现删除表中一列的重复数据,只留下一个,上面的这句sql语句哪里出错了