是要得到记录的总数吗?? select b.CompanyNo as CompanyNo, b.Name as CompanyName, b.ContactRen as CompanyContactRen, b.Tel as CompanyTel,count(*) as PassedRecCount from Company as b inner join ZhaoGong as a on a.CompanyNo = b.CompanyNo where a.IsPassed = 1 and a.IsPigeonhole = 0 group by b.CompanyNo,b.ContactRen,b.Tel,b.Name Select @@Rowcount
select
b.CompanyNo as CompanyNo, b.Name as CompanyName, b.ContactRen as CompanyContactRen, b.Tel as CompanyTel,count(*) as PassedRecCount
from Company as b inner join ZhaoGong as a on a.CompanyNo = b.CompanyNo where a.IsPassed = 1 and a.IsPigeonhole = 0 group by b.CompanyNo,b.ContactRen,b.Tel,b.Name
Select @@Rowcount