求助，统计问题，谢谢先！！

[Dream_1986]

表中有多余重复记录，要求统计除多余的总体数量例如
id text
1 sssss
2 ttttt
3 ddddd
4 mmmm
1 sssss
2 ttttt
3 ddddd
统计结果只有4条记录

谢谢！

[SQL77]

SELECT ID,[TEXT],COUNT(DISTINCT ID)AS NUM FROM TB GROUP BY ID,[TEXT]

[chuifengde]

select count(distinct id) from [Table] group by id,text

[--小F--]

select
 id,[text],count(distinct [text])  as num 
from
 tb 
group by
 id,[text]

[Dream_1986]

收到。。。非常感谢！！

[RubbyZK]

LZ参考如下代码

select count(id) as num,id,text from tb group by id,text 

[chuifengde]

总体数量？
select count(1) from (select distinct id,text from [table])aa
or
select count(distinct checksum(*)) from [Table] 

[ws_hgo]

create table #TT
(
  id int,
  [text] varchar(20)
)
insert into #TT select 1,'sssss'
insert into #TT select 2,'ttttt'
insert into #TT select 3,'ddddd'
insert into #TT select 4,'mmmm'
insert into #TT select 1,'sssss'
insert into #TT select 2,'ttttt'
insert into #TT select 3,'ddddd'

select count(distinct([text])) from #TT


-----------
4

(1 行受影响)

[Dream_1986]

有点问题，不是总量。。。。

[Dream_1986]

搞定
回复内容太短了！