我已经编写了select wrong查询,但它给出了不同的结果,令人惊讶的是,查询中没有任何错误。请让我知道。查询:
Select count(*) Count from conflux.dbo.SABR_Master M
Where M.Email in (
select top 26 Email from conflux.dbo.SABR_Master L
where (L.titleid In (Select titleid From sabr_titlemasters Where IsDisplay=1 And title like '%Account Executive%' OR title like '%Account Manager%' OR title like '%Accounts Manager%' OR title like '%admin%' ))
) and M.Email NOT IN (select Email from [sample client].dbo.Comm_CompanyData)发布于 2011-01-10 18:25:21
尝尝这个
Select count(*) Count
from conflux.dbo.SABR_Master M
Where M.Email in (select top 26
L.Email
from conflux.dbo.SABR_Master L
where (L.titleid In ( Select titleid
From sabr_titlemasters
Where IsDisplay=1 And
(title like '%Account Executive%' OR
title like '%Account Manager%' OR
title like '%Accounts Manager%' OR
title like '%admin%')))
ORDER BY L.Email) and
M.Email NOT IN (select Email
from [sample client].dbo.Comm_CompanyData)我已经在你的标题周围添加了括号,比如 OR's和一个命令,以保持你的26封电子邮件相同。如果未指定order by,则数据库可以按随机顺序返回它们,这可能会给出不同的结果。
https://stackoverflow.com/questions/4645600
复制相似问题