使用如下SQL语句计数时,明明只有一条数据,但是计数却为2,需要计数为1才对,这个如何解决呢?求问
select b.BQDM, a.SYXH, count(a.SYXH) as AA from dbo.SYZX a left join dbo.SYZX2 b on a.SYXH = cast(b.SYXH as varchar(16))
group by b.BQDM, a.SYXH
输出结果为:
select BQDM, SYXH,count(SYXH) [sl] from (
select distinct(b.BQDM) BQDM, a.SYXH from dbo.SYZX a left join dbo.SYZX2 b on a.SYXH = cast(b.SYXH as varchar(16))
) t group by BQDM, SYXH
这个需要SYZX2表,和SYZX表字段a.SYXH对应的数据只有一条才可以。。。你现在可以匹配到2条了啊
select b.BQDM, a.SYXH as AA from dbo.SYZX a left join dbo.SYZX2 b on a.SYXH = cast(b.SYXH as varchar(16))
这个sql有几条
elect b.BQDM, a.SYXH, count(DISTINCT a.SYXH) as AA from dbo.SYZX a left join dbo.SYZX2 b on a.SYXH = cast(b.SYXH as varchar(16))