SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select @@version;
CREATE TABLE [dbo].[runners](
	[runid] [varchar](8) NULL,
	[year] [smallint] NULL,
	[start] [numeric](5, 3) NULL,
	[end] [numeric](5, 3) NULL,
	[road] [varchar](2) NULL
) ON [PRIMARY]

INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(0.000 AS Numeric(5, 3)), CAST(0.585 AS Numeric(5, 3)), N'2')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(0.000 AS Numeric(5, 3)), CAST(7.777 AS Numeric(5, 3)), N'3')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(0.585 AS Numeric(5, 3)), CAST(4.980 AS Numeric(5, 3)), N'2')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(4.980 AS Numeric(5, 3)), CAST(7.777 AS Numeric(5, 3)), N'2')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(7.777 AS Numeric(5, 3)), CAST(11.857 AS Numeric(5, 3)), N'2')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(7.777 AS Numeric(5, 3)), CAST(11.857 AS Numeric(5, 3)), N'3')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(11.857 AS Numeric(5, 3)), CAST(13.274 AS Numeric(5, 3)), N'2')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(11.857 AS Numeric(5, 3)), CAST(13.274 AS Numeric(5, 3)), N'3')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(15.235 AS Numeric(5, 3)), CAST(21.021 AS Numeric(5, 3)), N'2')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(15.235 AS Numeric(5, 3)), CAST(21.021 AS Numeric(5, 3)), N'3')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(21.021 AS Numeric(5, 3)), CAST(22.142 AS Numeric(5, 3)), N'2')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(21.021 AS Numeric(5, 3)), CAST(22.142 AS Numeric(5, 3)), N'3')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(22.142 AS Numeric(5, 3)), CAST(25.946 AS Numeric(5, 3)), N'2')
INSERT [dbo].[runners] ([runid], [year], [start], [end], [road]) VALUES (N'01010000', 9, CAST(22.142 AS Numeric(5, 3)), CAST(25.946 AS Numeric(5, 3)), N'3')

(No column name)
Microsoft SQL Server 2016 (SP2-CU2) (KB4340355) - 13.0.5153.0 (X64) Jun 28 2018 17:24:28 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)