我想使用最小和最大函数,但要符合某些标准。
Create Table #Test (Id Int Identity(1,1), Category Varchar(100), DateTimeStamp DateTime)
Insert into #Test (Category,DateTimeStamp) values ('c1','2019-08-13 01:00:13.503')
Insert into #Test (Category,DateTimeStamp) values ('c1','2019-08-13 02:00:13.503')
Insert into #Test (Category,DateTimeStamp) values ('c1','2019-08-13 03:00:13.503')
Insert into #Test (Category,DateTimeStamp) values ('c1','2019-08-13 04:00:13.503')
Insert into #Test (Category,DateTimeStamp) values ('c1','2019-08-13 05:00:13.503')
Insert into #Test (Category,DateTimeStamp) values ('c2','2019-08-13 06:00:13.503')
Insert into #Test (Category,DateTimeStamp) values ('c2','2019-08-13 07:00:13.503')
Insert into #Test (Category,DateTimeStamp) values ('c2','2019-08-13 08:00:13.503')
Insert into #Test (Category,DateTimeStamp) values ('c2','2019-08-13 09:00:13.503')
Insert into #Test (Category,DateTimeStamp) values ('c2','2019-08-13 10:00:13.503')
Insert into #Test (Category,DateTimeStamp) values ('c1','2019-08-13 11:00:13.503')
带输出的当前查询
select category, min(DateTimeStamp) as minn , max(DateTimeStamp) as maxx from #Test
group by category
电流输出
预期输出