SELECT A.* FROM SerialData a, SerialData b where a.level1=b.level1 and a.level2=b.level2 and a.level3=b.level3 and a.level4=b.level4 and a.SNMPLeafNumber=b.SNMPLeafNumber and a.Category=b.Category and a.Name<>b.Name查找name不同但其他相同的行,但查不到,确信表里有这样的行。
pa Unit3 Mod1 Meters 1 www
pa Unit2 Mod1 Faults 1 www1
pa Unit2 Mod1 Faults 1 www1