sql查出具体时间段的数据

select a.时间 as '时间1',sum(a.来馆人数) as '来馆人数1' from ( SELECT datepart(hh, DataDatetime) as '时间',sum(PeopleNum) '来馆人数'

FROM        dbo.SysAdditionalData INNER JOIN

                      dbo.SysLibrary ON dbo.SysAdditionalData.SysLibraryId = dbo.SysLibrary.ID INNER JOIN

                      dbo.SysCustDevice ON dbo.SysLibrary.ID = dbo.SysCustDevice.SysLibraryId group by  datepart(hh, DataDatetime)  union  SELECT datepart(hh,D_Date) as '时间',sum(D_InNum) as '来馆人数' FROM          dbo.SysAdditionalData INNER JOIN

                      dbo.SysCustData ON dbo.SysAdditionalData.ID = dbo.SysCustData.ID INNER JOIN

                      dbo.SysCustDevice ON dbo.SysCustData.SysCustDeviceId = dbo.SysCustDevice.ID group by  datepart(hh, D_Date) )as a group by a.时间