急求一复杂语句
表a
ID Time
1 2006.1.1
1 2006.2.1
2 2006.1.1

计算出每个月每一天的不同ID记录总数。




[解决办法]
select convert(varchar(10),Time,120),count(ID)
from (select distinct ID,Time from 表a) a
group by convert(varchar(10),Time,120)
[解决办法]
Select
Count(Distinct ID) As 总数,
[Time]
From
a
Group By
[Time]
[解决办法]
--试试

select distinct time,(select count(*) from (select distinct id from a aa where aa.time =a.time)t)
from a

[解决办法]
select count(distinct id) 总数,Time 时间
from a
group by Time
[解决办法]
SELECT COUNT(id) AS Expr1, dt, id
FROM td
GROUP BY dt, id