SQL Server 怎么提取整点时间的记录,查询语句如何写

create table tb(H_Date datetime ,AlarmingPoint varchar(10),AlarmValue varchar(10))insert into tb values('2007-12-22 00:00:23', 'p1', '2.454') insert into tb values('2007-12-22 10:00:00', 'A1', '23.32') insert into tb values('2007-12-22 10:55:00', 'p1', '2.454') insert into tb values('2007-12-22 11:00:00', 'A1', '23.32') insert into tb values('2007-12-22 12:00:00', 'p1', '2.454') insert into tb values('2007-12-22 13:10:00', 'A1', '23.32') insert into tb values('2007-12-22 13:10:01', 'p1', '2.454') insert into tb values('2007-12-22 14:23:20', 'A1', '23.32') insert into tb values('2007-12-22 15:00:00', 'p1', '2.454') insert into tb values('2007-12-22 16:00:08', 'A1', '23.32') goselect * from tb where datepart(mi,h_date) = 0 and datepart(ss,h_date) = 0drop table tb/*H_Date                  AlarmingPoint AlarmValue----------------------- ------------- ----------2007-12-22 10:00:00.000 A1            23.322007-12-22 11:00:00.000 A1            23.322007-12-22 12:00:00.000 p1            2.4542007-12-22 15:00:00.000 p1            2.454(4 行受影响)*/