灰指甲拔掉会好吗:sql 要帮助

来源：百度文库编辑：杭州交通信息网时间：2024/06/07 02:34:52

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%'))

sql 要帮助求SQL高手帮助 SQL Server2000数据库故障请求帮助！谢谢急求帮助！关于SQL server2000问题！跪求sql英文联机帮助文档谁能具体点帮助我！！ASP+SQL连接数据库求pervasive.sql 2000i的中文帮助说明帮助做一个学生管理系统,用SQL做! 请问学SQL对ORCLE有帮助吗？初学SQL SERVER,请帮助推荐基本参考书