啪嗒砰3存档怎么用:sql 要帮助

来源:百度文库 编辑:中科新闻网 时间:2024/05/05 20:37:10
select count(*) from dbo.有名有email where (( email<>'%@yahoo%' ) and (email <> '%@ms%') and (email <> '%@sina%') and (email<>'%@hotmail%') and (email <> '%@kimo%') and (email <>'%@pchome%'))
得到的 数量还是 没有出去ms,yahoo 等后缀的邮箱地址阿

select count(*) from dbo.有名有email where not(( email like '%@yahoo%' ) and (email like '%@ms%') and (email like '%@sina%') and (email like '%@hotmail%') and (email like '%@kimo%') and (email like '%@pchome%'))