下面这段代码什么意思,主要是后面条件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(
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/27 11:25:59
![下面这段代码什么意思,主要是后面条件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(](/uploads/image/z/6366747-3-7.jpg?t=%E4%B8%8B%E9%9D%A2%E8%BF%99%E6%AE%B5%E4%BB%A3%E7%A0%81%E4%BB%80%E4%B9%88%E6%84%8F%E6%80%9D%2C%E4%B8%BB%E8%A6%81%E6%98%AF%E5%90%8E%E9%9D%A2%E6%9D%A1%E4%BB%B6delete+from+ware+where+ware_wareid++in+%EF%BC%88select+++ware_wareid++from+ware+where++ware_deleted+is+null++group+by+++ware_wareid+++having+count%EF%BC%88ware_wareid%EF%BC%89+%3E+1%EF%BC%89+and+rowid+not+in+%EF%BC%88select+min%EF%BC%88)
下面这段代码什么意思,主要是后面条件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有重复的记录