[求助] 帮我写了一个SQL Statement

小阿松

小弟遇到了一个SQL Statement 的难题, 希望各位能帮帮忙指导一下， 先谢谢了。

Table name : Report

ID	Process1	Process2
123456	Soak	Dry
123456	Soak	Wash
123446	Soak	Wash
123447	Soak	Wash

小弟要实现的结果：

if same serial exist and
process1 = 'soak' and process2 = 'dry' exist  then
delete serial with process1 = 'soak' and process2 = 'wash'

理想结果是上面粗体的那行会被deleted.
小弟尝试了很久都不成功。


希望大家能帮帮忙， 谢谢了。

兔仙人

写 STORED PROCEDURE 吧 ～

winmxaa

回复 1# 小阿松


    delete from report
where id in (
    select id from report
    group by id
    having count(*)>1
)
and process1 = 'Soak'
and process2 = 'Wash'