Sql 日期查询
丿渎灬魂 2011-05-27 03:40:05 Id Name Data
1 Leo | G450 2011-05-27 00:00:00.000
2 Leo | G450 2011-05-06 00:00:00.000
3 Leo | G450 2011-05-27 00:00:00.000
4 Leo | G450 2011-05-25 00:00:00.000
5 Leo | G450 2011-05-26 00:00:00.000
6 Leo | G460 2011-05-23 11:11:01.000
7 Leo | Y450 2011-05-21 00:00:00.000
8 Leo | Y450 2011-05-28 00:00:00.000
9 Leo | Y460 2011-05-27 00:00:00.000
要求查询:
1: 查询当天名字为XX查看的次数 比如说(查询Leo | G450当天点击的次数)
2: 查询一周内XX查看的次数
3: 产讯一月内XX查看的次数