假设“datetime”列的格式始终为 t_{int} 你可以用 STUFF 删除前2个字符，然后将该值转换为 int . 这允许您按数字排序，而不是按字典排序。然后你就可以得到 MIN 以及 MAX 用缺口和孤岛解决方案 t_ 前缀：

WITH YourTable AS(
    SELECT *
    FROM (VALUES('t_1',4),
                ('t_3',5),
                ('t_4',5),
                ('t_5',5),
                ('t_6',7),
                ('t_7',7),
                ('t_8',7),
                ('t_9',4),
                ('t_10',4),
                ('t_11',4))V(date_time,toolid)),
CTE AS(
    SELECT YT.date_time,
           YT.toolid,
           V.time_int,
           ROW_NUMBER() OVER (ORDER BY V.time_int) - 
           ROW_NUMBER() OVER (PARTITION BY YT.toolid ORDER BY V.time_int) AS Grp
    FROM YourTable YT
         CROSS APPLY(VALUES(TRY_CONVERT(int,STUFF(date_time,1,2,''))))V(time_int))
SELECT C.toolid,
       CONCAT('t_',MIN(C.time_int)) AS From_date_time,
       CONCAT('t_',MAX(C.time_int)) AS To_date_time
FROM CTE C
GROUP BY C.toolid,
         C.Grp;

编辑：未经测试，但基于op完全更改的样本数据，这现在只是一个简单的差距和孤岛问题：

WITH CTE AS(
    SELECT YT.date_time,
           YT.toolid,
           ROW_NUMBER() OVER (ORDER BY YT.date_time) - 
           ROW_NUMBER() OVER (PARTITION BY YT.toolid ORDER BY YT.date_time) AS Grp
    FROM dbo.YourTable YT)
SELECT C.toolid,
       MIN(C.date_time) AS From_date_time,
       MAX(C.date_time) AS To_date_time
FROM CTE C
GROUP BY C.toolid,
         C.Grp;