By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
declare @table table
(
id int identity(1,1) not null,
person_date datetime,
person varchar(100) null,
number_one int null
)
insert into @table VALUES('2019-09-02 00:00:00','test1',111)
insert into @table VALUES('2019-09-02 00:00:01','test1',111)
insert into @table VALUES('2019-09-02 00:00:02','test1',111)
insert into @table VALUES('2019-09-02 00:00:03','test2',333)
insert into @table VALUES('2019-09-02 00:00:04','test1',111)
insert into @table VALUES('2019-09-02 00:00:05','test2',333)
insert into @table VALUES('2019-09-02 00:00:06','test2',333)
insert into @table VALUES('2019-09-02 00:00:07','test3',444)
SELECT * FROM @table
| id | person_date | person | number_one |
|---|---|---|---|
| 1 | 2019-09-02 00:00:00.000 | test1 | 111 |
| 2 | 2019-09-02 00:00:01.000 | test1 | 111 |
| 3 | 2019-09-02 00:00:02.000 | test1 | 111 |
| 4 | 2019-09-02 00:00:03.000 | test2 | 333 |
| 5 | 2019-09-02 00:00:04.000 | test1 | 111 |
| 6 | 2019-09-02 00:00:05.000 | test2 | 333 |
| 7 | 2019-09-02 00:00:06.000 | test2 | 333 |
| 8 | 2019-09-02 00:00:07.000 | test3 | 444 |