删除记录问题？

[jinxi2007]

表rr：
dah fssq dymc
001 aaa 111
001 111
001 222
002 111
003 aaa 111
003 111

如何得到表：
dah fssq dymc
001 222
002 111
也就是说如何将表rr中，fssq=aaa，dymc=111的dah=001,003的dymc=111的所有记录删除。dah不止001.002.003这三个。

[taohua300]

delete from rr where fssq = 'aaa' or dymc = '111' and (dah = '001' or dah = '003')

[jinxi2007]

dah 不止001.002.003这三个，还有004,005……等许多，并不是把所有的dymc是111的都删除。

[ACMAIN_CHM]

delete from 表rr t where dymc=111 and exists (select 1 from 表rr where fssq=aaa and dymc=111 and dah=t.dah)

[wwwwb]

delete from TT where fssq = 'aaa' or (dymc = '111' and dah IN('001','003'))

[Q2565093493]

delete for