这个数据我看了一下,无法按照名称、地点、交货时间同时group by
也有可能实现思路不太一样。主要问题是缺乏一次性分组依据。
建议用代码实现。
create Table A
(
Name varchar(36),
Addr varchar(3),
SubTime Datetime,
Num int
)
insert into A values('A0001', 'P01', '2019-09-10 08:00:00', 8)
insert into A values('A0001', 'P01', '2019-09-10 09:00:00', 8)
insert into A values('A0001', 'P01', '2019-09-10 10:00:00', 8)
insert into A values('A0001', 'P01', '2019-09-10 11:00:00', 8)
insert into A values('A0001', 'P02', '2019-09-10 11:00:00', 8)
insert into A values('A0001', 'P02', '2019-09-10 12:00:00', 8)
insert into A values('A0001', 'P02', '2019-09-10 13:00:00', 8)
insert into A values('A0001', 'P01', '2019-09-10 13:00:00', 8)
insert into A values('A0001', 'P01', '2019-09-10 14:00:00', 8)
insert into A values('A0001', 'P02', '2019-09-10 14:00:00', 8)
select Name, Addr, Min(SubTime),Max(SubTime) from A group by Name, Addr
ericzhou