clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1228836 fiddles created (16647 in the last week).

CREATE TABLE T ([date] datetime, [Time] varchar(8), [place] varchar(1)) ; INSERT INTO T ([date], [Time], [place]) VALUES ('2020-07-01', '10:20:10', 'a'), ('2020-07-01', '11:20:10', 'a'), ('2020-07-01', '13:20:10', 'a'), ('2020-07-01', '10:20:10', 'b'), ('2020-07-01', '10:33:10', 'b') ;
5 rows affected
 hidden batch(es)


select * from T
date Time place
2020-07-01 00:00:00.000 10:20:10 a
2020-07-01 00:00:00.000 11:20:10 a
2020-07-01 00:00:00.000 13:20:10 a
2020-07-01 00:00:00.000 10:20:10 b
2020-07-01 00:00:00.000 10:33:10 b
 hidden batch(es)


select [date], max([Time]) Time, [place] from T group by [date], [place]
date Time place
2020-07-01 00:00:00.000 13:20:10 a
2020-07-01 00:00:00.000 10:33:10 b
 hidden batch(es)