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语句哪里出错了
------解决思路----------------------
你是什么数据库？ rowid 应该是 oracle 用法。