sql去重语句 sql语句“不包含”怎么写？

sql语句“不包含”怎么写？SQL语句使用like和not like处理包含和不包含关系的方法。1类SQL运算符语法中的“%”是通配符，这意味着任何字符select*from TT where tes

sql语句“不包含”怎么写？

SQL语句使用like和not like处理包含和不包含关系的方法。1类SQL运算符语法中的“%”是通配符，这意味着任何字符select*from TT where test Column like%d%”2uselect*from TT where test for records with the character“d”at the beging of the Column field Column like“d%”3uselect*from TT where test for the records with the character“d”at the Column field Column like%d”4从TT where test for the Column field Column with the character“d”at the。Not like不包含检索测试uSELECT*from TT where测试列字段不包含字符“d”uCOLUMN Not like %d%“

sql语句“不包含”怎么写？

Select*from table name where XM Not like “*small*”Select*from table name where XM “*small*”Select*from table name where Not（XM=“*small*”）Select*from table name where XM not in（“*small*”）

Select*from tablename wherexmnotlike“*small*”Select*from tablename wherexm<>“*small*”Select*from tablename wherenot（XM=“*small*”）Select*from tablename wherexmnotin（“*small*”）