select count(id) from testtable group by testtime 可以统计出每天的记录数
SELECT * FROM testtable GROUP BY CONVERT(varchar, max(FileCreateTime), 120 )CONVERT(varchar, max(FileCreateTime), 120 )--显示的天
请问gridview 的表头得背景怎么设置阿?
上面错了SELECT * FROM testtable GROUP BY CONVERT(varchar, FileCreateTime, 120 ) WHERE FileCreateTime BETWEEN TIME1 AND TIME2CONVERT(varchar, FileCreateTime, 120 )--显示的天
最好不要使用
WHERE FileCreateTime BETWEEN TIME1 AND TIME2CONVERT(varchar, FileCreateTime, 120 )--显示的天