sql - 删除相同序列号的重复状态

Question

我有下表，需要删除具有不同状态的重复序列号？！

标签： sqlms-access

Answer 1

这可能会有所帮助

delete from table1 where [s/n] IN (
    select [s/n] FROM Table1
    group by [s/n]
    having count(Distinct status ) > 1
);