旧爱晚成 河清海晏七七:sql 要帮助

来源:百度文库 编辑:高校问答 时间:2024/05/06 17:46:32
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%'))