日期:2014-05-16 浏览次数:20752 次
year week name begintime endtime checkin 2010 52 AAA 2010-12-26 00:00:00 2010-12-31 23:55:00 524 .... 2011 0 AAA 2011-01-01 00:00:00 2011-01-01 23:55:00 486 2011 1 AAA 2011-01-02 00:00:00 2011-01-08 23:55:00 576 2011 2 AAA 2011-01-09 00:00:00 2011-01-15 23:55:00 580 .... 2011 0 BBB 2011-01-01 00:00:00 2011-01-01 23:55:00 323 2011 1 BBB 2011-01-02 00:00:00 2011-01-08 23:55:00 238 2011 2 BBB 2011-01-09 00:00:00 2011-01-15 23:55:00 863 .... 2011 0 CCC 2011-01-01 00:00:00 2011-01-01 23:55:00 328 2011 1 CCC 2011-01-02 00:00:00 2011-01-08 23:55:00 876 2011 2 CCC 2011-01-09 00:00:00 2011-01-15 23:55:00 583 ....
select * from Table where name='AAA' and year=2011
year week name begintime endtime checkin 2011 0 AAA 2010-12-26 00:00:00 2011-01-01 23:55:00 486+524 2011 1 AAA 2011-01-02 00:00:00 2011-01-08 23:55:00 576 2011 2 AAA 2011-01-09 00:00:00 2011-01-15 23:55:00 580 .....