SQL Server 2017

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

CREATE TABLE mytable(
   id int
   ,HOLEID     VARCHAR(6) NOT NULL 
  ,[FROM]       NUMERIC(6,2) NOT NULL
  ,[TO]         NUMERIC(6,2) NOT NULL
  ,ALTERATION VARCHAR(10) NOT NULL
);
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',0,132.6,'AA-LT-1');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',132.6,171.28,'ARG-1-MSI');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',171.28,177.65,'AA-LT-1');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',177.65,178.8,'AA-LT-1');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',178.8,213.9,'AA-LT-1');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',213.9,214.8,'AA-LT-1');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',214.8,216.8,'AA-LT-1');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',216.8,219.4,'ARG-2-Kaol');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',219.4,219.9,'ARG-2-Kaol');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',219.9,220.3,'ARG-2-Kaol');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',220.3,220.8,'ARG-2-Kaol');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',220.8,232.6,'ARG-2-Kaol');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',232.6,249.45,'ARG-1-MSI');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',249.45,256.9,'ARG-1-MSI');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',256.9,265.7,'ARG-2-Kaol');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',265.7,290.1,'ARG-1-MSI');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',290.1,294.85,'ARG-2-Kaol');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',294.85,308.4,'ARG-1-MSI');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',308.4,310.35,'ARG-1-MSI');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',310.35,325,'ARG-1-MSI');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',325,331.12,'ARG-2-Kaol');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',331.12,332.1,'ARG-2-Kaol');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',332.1,333.1,'ARG-1-MSI');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',333.1,333.6,'ARG-1-MSI');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',333.6,353.6,'ARG-1-MSI');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',353.6,368.55,'ARG-1-MSI');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',368.55,376.6,'ARG-1-MSI');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',376.6,382.7,'ARG-1-MSI');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',382.7,396.1,'ARG-2-Kaol');
INSERT INTO mytable(HOLEID,[FROM],[TO],ALTERATION) VALUES ('HOLEV2',396.1,416.2,'ARG-1-MSI');

30 rows affected

min_from	max_to	alteration
0.00	132.60	AA-LT-1
132.60	171.28	ARG-1-MSI
171.28	216.80	AA-LT-1
216.80	232.60	ARG-2-Kaol
232.60	256.90	ARG-1-MSI
256.90	265.70	ARG-2-Kaol
265.70	290.10	ARG-1-MSI
290.10	294.85	ARG-2-Kaol
294.85	325.00	ARG-1-MSI
325.00	332.10	ARG-2-Kaol
332.10	382.70	ARG-1-MSI
382.70	396.10	ARG-2-Kaol
396.10	416.20	ARG-1-MSI