MSSQL中用WITHAS和PIVOT来统计编辑新闻发布时间详情和总数(二)
014-11-27 16:19:59 1 0 0
2014-11-27 16:41:57 1 0 0
2014-11-28 08:46:40 1 0 0
2014-11-28 09:03:07 0 1 0
2014-11-28 09:27:11 0 1 0
2014-11-28 09:44:44 0 0 1
2014-11-28 09:48:48 0 0 1
2014-11-28 09:53:52 0 1 0
2014-11-28 10:34:09 0 0 1
2014-11-28 10:39:20 0 1 0
2014-11-28 10:51:16 1 0 0
2014-11-28 11:38:25 1 0 0
2014-11-28 11:44:27 1 0 0
2014-11-28 14:36:29 1 0 0
2014-11-28 15:03:20 0 0 1
2014-11-28 15:34:43 0 0 1
2014-11-28 15:40:29 1 0 0
2014-11-28 15:40:42 0 0 1
2014-11-28 15:50:40 1 0 0
2014-11-28 16:07:17 1 0 0
2014-11-28 16:09:41 0 1 0
2014-11-28 16:10:12 0 0 1
2014-11-28 16:27:12 0 0 1
2014-11-28 17:02:38 0 0 1
2014-11-28 21:24:18 0 0 0
2014-11-29 08:31:36 0 0 0
2014-11-29 12:32:32 0 0 1
2014-11-29 12:35:14 0 0 1
2014-11-29 12:44:43 0 0 1
2014-11-29 13:13:16 0 0 1
2014-11-29 13:20:21 0 0 1
2014-11-29 13:30:12 0 0 1
2014-11-29 13:42:31 0 0 1
2014-11-29 20:30:36 0 0 0
2014-11-29 20:50:03 0 0 0
2014-11-29 21:12:30 0 0 1
2014-11-30 12:12:08 0 0 1
2014-11-30 12:30:36 0 0 1
2014-11-30 12:33:36 0 0 1
2014-11-30 12:37:54 0 0 1
2014-11-30 12:43:38 0 0 1
2014-11-30 12:52:18 0 0 1
2014-11-30 12:56:47 0 0 1
2014-11-30 17:55:54 0 0 1
2014-11-30 17:55:55 0 0 1
2014-11-30 18:30:41 0 0 1
2014-11-30 18:48:15 0 0 1
2014-11-30 18:54:55 0 0 1
2014-11-30 18:56:59 0 0 1
2014-11-30 19:15:30 0 0 1
2014-11-30 19:29:41 0 0 1
总计 36 39 66