Is it possible to group rows by difference to each other in T-SQL, Sql Server

Is it possible to group rows by difference to each other in T-SQL

Language: Layout:

View schema
Execution time: 0 sec, rows selected: 7, rows affected: 7, absolute service time: 0,17 sec

fork mode | history

  
id
starttime
endtime
duration
batch

1
1
2017-10-06 10:59:48
2017-10-06 10:59:58
10
1

2
2
2017-10-06 11:00:02
2017-10-06 11:00:06
4
1

3
3
2017-10-06 11:00:15
2017-10-06 11:00:22
7
1

4
4
2017-10-06 11:00:30
2017-10-06 11:00:39
9
1

5
5
2017-10-06 15:34:31
2017-10-06 15:34:45
14
2

6
6
2017-10-06 15:34:48
2017-10-06 15:34:56
8
2

7
7
2017-10-06 15:34:52
2017-10-06 15:34:59
7
2

λ

                                      .NET NoSQL database for rapid development