素材：
select cmac,InTime from Interface_SurfingLog_WP_SnifferData
现在要查询每个小时cmac个数，这个是不去重的：
SELECT CONVERT(VARCHAR(10),[InTime],120)[日期\小时],
SUM(CASE WHEN DATEPART(HH,[InTime])=1 THEN 1 END)[1],
SUM(CASE WHEN DATEPART(HH,[InTime])=2 THEN 1 END)[2],
SUM(CASE WHEN DATEPART(HH,[InTime])=3 THEN 1 END)[3],
SUM(CASE WHEN DATEPART(HH,[InTime])=4 THEN 1 END)[4],
SUM(CASE WHEN DATEPART(HH,[InTime])=5 THEN 1 END)[5],
SUM(CASE WHEN DATEPART(HH,[InTime])=6 THEN 1 END)[6],
SUM(CASE WHEN DATEPART(HH,[InTime])=7 THEN 1 END)[7],
SUM(CASE WHEN DATEPART(HH,[InTime])=8 THEN 1 END)[8],
SUM(CASE WHEN DATEPART(HH,[InTime])=9 THEN 1 END)[9],
SUM(CASE WHEN DATEPART(HH,[InTime])=10 THEN 1 END)[10],
SUM(CASE WHEN DATEPART(HH,[InTime])=11 THEN 1 END)[11],
SUM(CASE WHEN DATEPART(HH,[InTime])=12 THEN 1 END)[12],
SUM(CASE WHEN DATEPART(HH,[InTime])=13 THEN 1 END)[13],
SUM(CASE WHEN DATEPART(HH,[InTime])=14 THEN 1 END)[14],
SUM(CASE WHEN DATEPART(HH,[InTime])=15 THEN 1 END)[15],
SUM(CASE WHEN DATEPART(HH,[InTime])=16 THEN 1 END)[16],
SUM(CASE WHEN DATEPART(HH,[InTime])=17 THEN 1 END)[17],
SUM(CASE WHEN DATEPART(HH,[InTime])=18 THEN 1 END)[18],
SUM(CASE WHEN DATEPART(HH,[InTime])=19 THEN 1 END)[19],
SUM(CASE WHEN DATEPART(HH,[InTime])=20 THEN 1 END)[20],
SUM(CASE WHEN DATEPART(HH,[InTime])=21 THEN 1 END)[21],
SUM(CASE WHEN DATEPART(HH,[InTime])=22 THEN 1 END)[22],
SUM(CASE WHEN DATEPART(HH,[InTime])=23 THEN 1 END)[23],
SUM(CASE WHEN DATEPART(HH,[InTime])=24 THEN 1 END)[24]
FROM[Interface_SurfingLog_WP_SnifferData]GROUP BY CONVERT(VARCHAR(10),[InTime],120)
ORDER BY[日期\小时]DESC
求教如何统计个数的时候根据cmac去重，去重后查询结果2015-09-23 14点应该是2个不是3个，有重复的cmac
不要受我提供的sql影响，有其他写法更好
