假设使用SQL Server 2008或更高版本：
SELECt [Date] = ConVERT(DATE, LogDate), [Sum] = COUNT(*)FROM dbo.Log_Table_NameWHERe [Type] = 'DBError'GROUP BY ConVERT(DATE, LogDate)ORDER BY [Date];
假设使用SQL Server 2008或更高版本：
SELECt [Date] = ConVERT(DATE, LogDate), [Sum] = COUNT(*)FROM dbo.Log_Table_NameWHERe [Type] = 'DBError'GROUP BY ConVERT(DATE, LogDate)ORDER BY [Date];
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
