下面这段代码什么意思,主要是后面条件delete from ware where ware_wareid in （select ware_wareid from ware where ware_deleted is null group by ware_wareid having count（ware_wareid） > 1） and rowid not in （select min（
来源：学生作业帮助网 编辑：六六作业网 时间：2025/02/02 00:43:55
下面这段代码什么意思,主要是后面条件delete from ware where ware_wareid in （select ware_wareid from ware where ware_deleted is null group by ware_wareid having count（ware_wareid） > 1） and rowid not in （select min（
下面这段代码什么意思,主要是后面条件
delete from ware
where ware_wareid in （select ware_wareid from ware where ware_deleted is null group by ware_wareid having count（ware_wareid） > 1）
and rowid not in （select min（rowid） from ware where ware_deleted is null group by ware_wareid having count（ware_wareid ）>1）
下面这段代码什么意思,主要是后面条件delete from ware where ware_wareid in （select ware_wareid from ware where ware_deleted is null group by ware_wareid having count（ware_wareid） > 1） and rowid not in （select min（
将表ware中,字段ware_deleted值为空的记录选出来,再选择ware_wareid有重复的记录,再从里面将rowid最小的剔除后,其余的记录全部删除.
delete from ware
where ware_wareid in -- 其余的记录全部删除
（select ware_wareid
from ware
where ware_deleted is null -- 字段ware_deleted值为空
group by ware_wareid
having count（ware_wareid） > 1） -- 选择ware_wareid有重复的记录
and rowid not in -- 将rowid最小的剔除后
（select min（rowid）
from ware
where ware_deleted is null -- 字段ware_deleted值为空
group by ware_wareid
having count（ware_wareid ）>1） -- 选择ware_wareid有重复的记录