小小地散个分..^^

[cookies10wen]

请问如何删除不符合条件的数据???

比例我要Delect除name=a,name=b外的数据,,用什么函数实现?

[水族杰纶]

DELETE TB WHERE NAME NOT IN('A','B')

[lgx0914]

not exists

[--小F--]

not in('a','b')

[SQL77]

DELETE FROM TB WHERE NAME NOT IN (A,B) AND NAME IS NOT NULL

[子陌红尘]

delete from 表 where name!='a' and name!='b'

[lgx0914]

[code=SQL]DELETE TB WHERE not exists (select * from name=a or name =b)code]

[xuejie09242]

DELETE table1 WHERE NAME NOT IN('A','B')

[ai_li7758521]

delete from tb 
where charindex(','+name+',',',a,b,')=0

[zhongxiutao123]

not exists