常用sql语句

按天统计

SELECT COUNT(*), CONVERT(VARCHAR(24),[StartTime],112) AS d  FROM [Logs]  GROUP BY   CONVERT(VARCHAR(24),[StartTime],112) ORDER BY d