统计最多次数的一天
有表结构如下：
ID IPID LogAddTime
112007-3-29 9:41:00
212007-1-29 10:16:00
312007-3-28 10:16:00
442007-2-28 10:17:00
512006-3-27 10:17:00
632007-3-29 10:17:00
712007-3-29 10:17:00
832007-1-29 10:17:00
912007-3-29 10:17:00
1082007-3-28 10:25:00
1112007-1-29 10:25:00
1212006-3-25 10:26:00
1382007-3-28 10:26:00
1422007-3-29 10:58:00
1522007-2-9 10:58:00
1622007-3-29 10:58:00
17102007-3-29 10:58:00
1822007-3-29 10:58:00
1992007-3-29 10:58:00
2022007-3-29 10:58:00
想取出IPID数量最多的一天？
sql怎么写 谢谢高手
[解决办法]
IPID是个数还是一个id?重复的算不算?select top 1 Year(LogAddTime),Month(LogAddTime),Day(LogAddTime),COUNT( DISTINCT IPID)from 表group by Year(LogAddTime),Month(LogAddTime),Day(LogAddTime) order by COUNT( DISTINCT IPID) desc
[解决办法]
IPID是id
