关于SqlServer2005统计sql的求助
各位大侠:小弟我对SqlServer不熟悉,所以请各位大仙帮帮忙.
有个表,结构如下:
CREATE TABLE [dbo].[WarnLog](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DevNum] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
[LineABC] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
[DevID] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
[DevState] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
[GzParam] [varchar](8000) COLLATE Chinese_PRC_CI_AS NULL,
[ReportTime] [datetime] NULL,
CONSTRAINT [PK_WarnLog] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
现在我要对该表进行统计,具体要求是按DevID统计每小时,如何写sql或者函数呢?(ReportTime是时间)