add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
28 rows affected
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_PRECISION_RADIX NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_CATALOG CHARACTER_SET_SCHEMA CHARACTER_SET_NAME COLLATION_CATALOG COLLATION_SCHEMA COLLATION_NAME DOMAIN_CATALOG DOMAIN_SCHEMA DOMAIN_NAME
fiddle_35f33c3d1bf943789826c6f1e19719f5 dbo py id 1 null NO int null null 10 10 0 null null null null null null null null null null
fiddle_35f33c3d1bf943789826c6f1e19719f5 dbo py high 2 null YES numeric null null 10 10 3 null null null null null null null null null null
id high running_max seqnum lastmax
1 28.120 28.120 1 1
2 27.450 28.120 2 1
3 27.680 28.120 3 1
4 27.400 28.120 4 1
5 28.090 28.120 5 1
6 28.070 28.120 6 1
7 28.200 28.200 7 7
8 28.700 28.700 8 8
9 28.050 28.700 9 8
10 28.195 28.700 10 8
11 27.770 28.700 11 8
12 28.270 28.700 12 8
13 28.185 28.700 13 8
14 28.510 28.700 14 8
15 28.500 28.700 15 8
16 28.230 28.700 16 8
17 27.590 28.700 17 8
18 27.600 28.510 18 8
19 27.310 28.510 19 8
20 27.110 28.510 20 8
21 26.870 28.510 21 8
22 27.120 28.510 22 8
23 27.220 28.510 23 8
24 27.300 28.500 24 8
25 27.660 28.230 25 8
26 27.405 27.660 26 8
27 27.540 27.660 27 8
28 27.650 27.660 28 8 
Warning: Null value is eliminated by an aggregate or other SET operation.
id high running_max seqnum lastmax
1 28.120 28.120 1 1
2 27.450 28.120 2 1
3 27.680 28.120 3 1
4 27.400 28.120 4 1
5 28.090 28.120 5 1
6 28.070 28.120 6 1
7 28.200 28.200 7 7
8 28.700 28.700 8 8
9 28.050 28.700 9 8
10 28.195 28.700 10 8
11 27.770 28.700 11 8
12 28.270 28.700 12 8
13 28.185 28.700 13 8
14 28.510 28.700 14 8
15 28.500 28.700 15 8
16 28.230 28.700 16 8
17 27.590 28.700 17 8
18 27.600 28.510 18 8
19 27.310 28.510 19 8
20 27.110 28.510 20 8
21 26.870 28.510 21 8
22 27.120 28.510 22 8
23 27.220 28.510 23 8
24 27.300 28.500 24 8
25 27.660 28.230 25 8
26 27.405 27.660 26 8
27 27.540 27.660 27 8
28 27.650 27.660 28 8 
Warning: Null value is eliminated by an aggregate or other SET operation.


28 rows affected
id high running_max seqnum lastmax
1 28.120 28.120 1 1
2 27.450 28.120 2 1
3 27.680 28.120 3 1
4 27.400 28.120 4 1
5 28.090 28.120 5 1
6 28.070 28.120 6 1
7 28.200 28.200 7 7
8 28.700 28.700 8 8
9 28.050 28.700 9 8
10 28.195 28.700 10 8
11 27.770 28.700 11 8
12 28.270 28.700 12 8
13 28.185 28.700 13 8
14 28.510 28.700 14 8
15 28.500 28.700 15 8
16 28.230 28.700 16 8
17 27.590 28.700 17 8
18 27.600 28.510 18 8
19 27.310 28.510 19 8
20 27.110 28.510 20 8
21 26.870 28.510 21 8
22 27.120 28.510 22 8
23 27.220 28.510 23 8
24 27.300 28.500 24 8
25 27.660 28.230 25 8
26 27.405 27.660 26 8
27 27.540 27.660 27 8
28 27.650 27.660 28 8 
Warning: Null value is eliminated by an aggregate or other SET operation.
id high running_max lastmax
1 28.120 28.120 1
2 27.450 28.120 1
3 27.680 28.120 1
4 27.400 28.120 1
5 28.090 28.120 1
6 28.070 28.120 1
7 28.200 28.200 7
8 28.700 28.700 8
9 28.050 28.700 8
10 28.195 28.700 8
11 27.770 28.700 8
12 28.270 28.700 8
13 28.185 28.700 8
14 28.510 28.700 8
15 28.500 28.700 8
16 28.230 28.700 8
17 27.590 28.700 8
18 27.600 28.510 14
19 27.310 28.510 14
20 27.110 28.510 14
21 26.870 28.510 14
22 27.120 28.510 14
23 27.220 28.510 14
24 27.300 28.500 15
25 27.660 28.230 16
26 27.405 27.660 25
27 27.540 27.660 25
28 27.650 27.660 25