SQL Server 2019

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

create table EXTAUTOTABLE(
Cur_Date datetime,
DieNumber float,
CLD1 float,
CLD2 float,
CLD3 float);

insert into EXTAUTOTABLE values ('2020-12-09 15:44:49', 38.11402,0.3448946,0.3328909,0.3433484);
insert into EXTAUTOTABLE values ('2020-12-09 15:53:09', 38.11402,0.3217009,0.3264211,0.3272755);
insert into EXTAUTOTABLE values ('2020-12-09 16:20:21', 38.11402,0.3254038,0.3179167,0.3227589);
insert into EXTAUTOTABLE values ('2020-12-09 16:23:31', 38.11402,1.588891,2.692383,2.962041);
insert into EXTAUTOTABLE values ('2020-12-09 16:26:39', 38.11402,1.664129,2.684204,2.866458);
insert into EXTAUTOTABLE values ('2020-12-09 16:29:48', 38.11402,1.420513,2.498451,2.763877);
insert into EXTAUTOTABLE values ('2020-12-09 16:32:57', 38.11402,1.500186,2.523395,2.819908);
insert into EXTAUTOTABLE values ('2020-12-09 16:36:06', 38.11402,1.557275,2.274571,2.694336);
insert into EXTAUTOTABLE values ('2020-12-09 16:39:16', 38.11402,1.493838,2.393103,2.672852);
insert into EXTAUTOTABLE values ('2020-12-09 16:42:25', 38.11402,1.596582,2.559528,2.839806);
insert into EXTAUTOTABLE values ('2020-12-09 16:45:33', 38.11402,1.538598,2.477495,2.727621);
insert into EXTAUTOTABLE values ('2020-12-09 16:48:42', 38.11402,1.412985,2.613809,2.81238);
insert into EXTAUTOTABLE values ('2020-12-09 16:51:52', 38.11402,1.654037,2.671997,2.836835);
insert into EXTAUTOTABLE values ('2020-12-09 16:55:01', 38.11402,1.607528,2.602172,2.742433);
insert into EXTAUTOTABLE values ('2020-12-09 16:58:09', 38.11402,1.510602,2.633992,2.839643);
insert into EXTAUTOTABLE values ('2020-12-09 17:01:19', 38.11402,1.665797,2.636962,2.839928);
insert into EXTAUTOTABLE values ('2020-12-09 17:04:27', 38.11402,1.648544,2.52075,2.809288);
insert into EXTAUTOTABLE values ('2020-12-09 17:07:36', 38.11402,1.40973,2.3411,2.702149);
insert into EXTAUTOTABLE values ('2020-12-09 17:10:45', 38.11402,1.204161,2.100048,2.44657);
insert into EXTAUTOTABLE values ('2020-12-09 17:13:54', 38.11402,1.080135,2.038971,2.409338);
insert into EXTAUTOTABLE values ('2020-12-09 17:17:03', 38.11402,1.017268,2.057364,2.391272);
insert into EXTAUTOTABLE values ('2020-12-09 17:20:12', 38.11402,1.020198,1.997589,2.335485);
insert into EXTAUTOTABLE values ('2020-12-09 17:23:21', 38.11402,1.152361,2.089509,2.455441);
insert into EXTAUTOTABLE values ('2020-12-09 17:26:30', 38.11402,1.032853,2.013947,2.390539);
insert into EXTAUTOTABLE values ('2020-12-09 17:29:39', 38.11402,1.051448,1.989817,2.351151);
insert into EXTAUTOTABLE values ('2020-12-09 17:32:49', 38.11402,1.079769,2.144076,2.516233);
insert into EXTAUTOTABLE values ('2020-12-09 17:35:57', 38.11402,1.363383,2.30517,2.570596);
insert into EXTAUTOTABLE values ('2020-12-09 17:39:06', 38.11402,1.278503,2.321528,2.57849);
insert into EXTAUTOTABLE values ('2020-12-09 17:42:15', 38.11402,1.20176,2.144035,2.492958);
insert into EXTAUTOTABLE values ('2020-12-09 17:45:25', 38.11402,1.41738,2.398474,2.725994);
insert into EXTAUTOTABLE values ('2020-12-09 17:48:33', 38.11402,1.593693,2.585407,2.906986);
insert into EXTAUTOTABLE values ('2020-12-09 17:51:42', 38.11402,1.455263,2.507078,2.827883);
insert into EXTAUTOTABLE values ('2020-12-09 17:54:51', 38.11402,1.423768,2.503131,2.790611);
insert into EXTAUTOTABLE values ('2020-12-09 17:58:01', 38.11402,1.42031,2.5732,2.895389);
insert into EXTAUTOTABLE values ('2020-12-09 18:01:10', 38.11402,1.78559,2.706706,2.922326);
insert into EXTAUTOTABLE values ('2020-12-09 18:04:18', 38.11402,1.721991,2.529986,2.928674);
insert into EXTAUTOTABLE values ('2020-12-09 18:07:27', 38.11402,1.707912,2.492714,2.968388);
insert into EXTAUTOTABLE values ('2020-12-09 18:10:36', 38.11402,1.428611,2.338781,2.666951);
insert into EXTAUTOTABLE values ('2020-12-09 18:13:45', 38.11402,1.222064,2.292719,2.679972);
insert into EXTAUTOTABLE values ('2020-12-09 18:16:54', 38.11402,1.412701,2.346675,2.59851);
insert into EXTAUTOTABLE values ('2020-12-09 18:20:04', 38.11402,1.329976,2.257155,2.528033);
insert into EXTAUTOTABLE values ('2020-12-09 18:23:12', 38.11402,1.441103,2.298416,2.584838);
insert into EXTAUTOTABLE values ('2020-12-09 18:26:21', 38.11402,1.186094,2.210117,2.570189);
insert into EXTAUTOTABLE values ('2020-12-09 18:29:31', 38.11402,1.48806,2.421424,2.636922);
insert into EXTAUTOTABLE values ('2020-12-09 18:32:40', 38.11402,1.423484,2.30928,2.576577);
insert into EXTAUTOTABLE values ('2020-12-09 18:35:48', 38.11402,1.40383,2.284744,2.563109);
insert into EXTAUTOTABLE values ('2020-12-09 18:38:57', 38.11402,1.305114,2.182325,2.510048);
insert into EXTAUTOTABLE values ('2020-12-09 18:42:06', 38.11402,1.213113,2.282872,2.58675);
insert into EXTAUTOTABLE values ('2020-12-09 18:45:15', 38.11402,1.356547,2.393184,2.751181);
insert into EXTAUTOTABLE values ('2020-12-09 18:48:24', 38.11402,1.330546,2.37821,2.621703);
insert into EXTAUTOTABLE values ('2020-12-09 18:51:33', 38.11402,1.412863,2.315058,2.639485);
insert into EXTAUTOTABLE values ('2020-12-09 18:54:42', 38.11402,1.347107,2.307408,2.58614);
insert into EXTAUTOTABLE values ('2020-12-09 18:57:51', 38.11402,1.324402,2.29634,2.558185);
insert into EXTAUTOTABLE values ('2020-12-09 19:01:00', 38.11402,1.47512,2.307652,2.682373);
insert into EXTAUTOTABLE values ('2020-12-09 19:04:09', 38.11402,1.445212,2.332311,2.655151);
insert into EXTAUTOTABLE values ('2020-12-09 19:07:19', 38.11402,1.368551,2.295933,2.532916);
insert into EXTAUTOTABLE values ('2020-12-09 19:10:29', 38.11402,1.408794,2.26159,2.516477);
insert into EXTAUTOTABLE values ('2020-12-09 19:13:38', 38.11402,1.322042,2.209872,2.486814);
insert into EXTAUTOTABLE values ('2020-12-09 19:16:47', 38.11402,1.197854,2.369421,2.803265);
insert into EXTAUTOTABLE values ('2020-12-09 19:19:56', 38.11402,1.288228,2.393184,2.718181);
insert into EXTAUTOTABLE values ('2020-12-09 19:23:06', 38.11402,1.276142,2.382076,2.736004);
insert into EXTAUTOTABLE values ('2020-12-09 19:26:16', 38.11402,1.119117,2.237217,2.573688);
insert into EXTAUTOTABLE values ('2020-12-09 19:29:25', 38.11402,1.373149,2.493243,2.869103);
insert into EXTAUTOTABLE values ('2020-12-09 19:37:26', 38.11402,0.7701126,1.79971,2.199008);
insert into EXTAUTOTABLE values ('2020-12-09 19:40:35', 38.11402,0.8777803,1.963816,2.348628);
insert into EXTAUTOTABLE values ('2020-12-09 19:43:44', 38.11402,0.9146054,2.03181,2.36763);
insert into EXTAUTOTABLE values ('2020-12-09 19:46:53', 38.11402,1.095923,2.221632,2.55729);
insert into EXTAUTOTABLE values ('2020-12-09 19:50:03', 38.11402,1.076554,2.00414,2.414181);
insert into EXTAUTOTABLE values ('2020-12-09 19:53:12', 38.11402,1.012955,1.999095,2.355871);
insert into EXTAUTOTABLE values ('2020-12-09 19:56:21', 38.11402,1.007543,2.07071,2.410559);
insert into EXTAUTOTABLE values ('2020-12-09 19:59:30', 38.11402,1.062109,2.022939,2.295282);
insert into EXTAUTOTABLE values ('2020-12-09 20:02:39', 38.11402,1.00384,2.054882,2.397619);
insert into EXTAUTOTABLE values ('2020-12-09 20:05:48', 38.11402,1.017878,2.030671,2.413937);
insert into EXTAUTOTABLE values ('2020-12-09 20:08:57', 38.11402,0.9800767,1.925973,2.256586);
insert into EXTAUTOTABLE values ('2020-12-09 20:12:06', 38.11402,0.989517,2.031566,2.393876);
insert into EXTAUTOTABLE values ('2020-12-09 20:15:15', 38.11402,0.9977365,2.016429,2.367427);
insert into EXTAUTOTABLE values ('2020-12-09 20:18:25', 38.11402,1.013118,2.014964,2.390295);
insert into EXTAUTOTABLE values ('2020-12-09 20:21:33', 38.11402,0.9961496,1.996572,2.349604);
insert into EXTAUTOTABLE values ('2020-12-09 20:24:42', 38.11402,1.085832,2.015493,2.394324);
insert into EXTAUTOTABLE values ('2020-12-09 20:27:52', 38.11402,1.008886,1.991648,2.35758);
insert into EXTAUTOTABLE values ('2020-12-18 13:10:05', 38.11402,0.6208184,0.5599451,0.5663742);
insert into EXTAUTOTABLE values ('2020-12-18 13:32:58', 38.11402,0.07491158,0.7891152,1.048641);
insert into EXTAUTOTABLE values ('2020-12-18 13:34:06', 38.11402,0.3331756,1.24534,1.595931);
insert into EXTAUTOTABLE values ('2020-12-18 13:35:13', 38.11402,0.4551664,1.435202,1.762926);
insert into EXTAUTOTABLE values ('2020-12-18 13:36:21', 38.11402,0.575733,1.714341,1.916899);
insert into EXTAUTOTABLE values ('2020-12-18 13:37:28', 38.11402,0.5757737,1.625798,1.938099);
insert into EXTAUTOTABLE values ('2020-12-18 13:38:36', 38.11402,0.5691818,1.501935,1.816271);
insert into EXTAUTOTABLE values ('2020-12-18 13:39:43', 38.11402,0.5050939,1.497012,1.867948);
insert into EXTAUTOTABLE values ('2020-12-18 13:40:51', 38.11402,0.5509524,1.525821,1.879382);
insert into EXTAUTOTABLE values ('2020-12-18 13:41:58', 38.11402,0.5769944,1.571516,1.933827);
insert into EXTAUTOTABLE values ('2020-12-18 13:43:06', 38.11402,0.3271127,1.22357,1.431296);
insert into EXTAUTOTABLE values ('2020-12-18 13:44:13', 38.11402,0.2987106,1.171445,1.569807);
insert into EXTAUTOTABLE values ('2020-12-18 13:45:21', 38.11402,0.4075176,1.359518,1.738389);
insert into EXTAUTOTABLE values ('2020-12-18 13:46:28', 38.11402,0.6651306,1.747138,2.166944);
insert into EXTAUTOTABLE values ('2020-12-18 13:47:36', 38.11402,0.5809414,1.569197,1.918324);
insert into EXTAUTOTABLE values ('2020-12-18 13:48:43', 38.11402,0.5332112,1.516136,1.857287);
insert into EXTAUTOTABLE values ('2020-12-18 13:49:51', 38.11402,0.5767096,1.565169,2.018748);
insert into EXTAUTOTABLE values ('2020-12-18 13:50:59', 38.11402,0.5815111,1.530053,1.877958);
insert into EXTAUTOTABLE values ('2020-12-18 13:52:06', 38.11402,0.5822029,1.5517,1.893746);
insert into EXTAUTOTABLE values ('2020-12-18 13:53:14', 38.11402,0.5718267,1.503604,1.844551);
insert into EXTAUTOTABLE values ('2020-12-18 13:54:21', 38.11402,0.5731288,1.5423,1.910836);
insert into EXTAUTOTABLE values ('2020-12-18 13:55:29', 38.11402,0.5767096,1.537296,1.906605);

102 rows affected

Select top 100 row_number() over (order by CLD1) rn, *
  FROM EXTAUTOTABLE
 WHERE CLD1<>0 
   And CLD2<>0
   And CLD3<>0 
   And DieNumber=38.11402


rn
Cur_Date
DieNumber
CLD1
CLD2
CLD3


1
2020-12-18 13:32:58.000
38.11402
0.07491158
0.7891152
1.048641

2
2020-12-18 13:44:13.000
38.11402
0.2987106
1.171445
1.569807

3
2020-12-09 15:53:09.000
38.11402
0.3217009
0.3264211
0.3272755

4
2020-12-09 16:20:21.000
38.11402
0.3254038
0.3179167
0.3227589

5
2020-12-18 13:43:06.000
38.11402
0.3271127
1.22357
1.431296

6
2020-12-18 13:34:06.000
38.11402
0.3331756
1.24534
1.595931

7
2020-12-09 15:44:49.000
38.11402
0.3448946
0.3328909
0.3433484

8
2020-12-18 13:45:21.000
38.11402
0.4075176
1.359518
1.738389

9
2020-12-18 13:35:13.000
38.11402
0.4551664
1.435202
1.762926

10
2020-12-18 13:39:43.000
38.11402
0.5050939
1.497012
1.867948

11
2020-12-18 13:48:43.000
38.11402
0.5332112
1.516136
1.857287

12
2020-12-18 13:40:51.000
38.11402
0.5509524
1.525821
1.879382

13
2020-12-18 13:38:36.000
38.11402
0.5691818
1.501935
1.816271

14
2020-12-18 13:53:14.000
38.11402
0.5718267
1.503604
1.844551

15
2020-12-18 13:54:21.000
38.11402
0.5731288
1.5423
1.910836

16
2020-12-18 13:36:21.000
38.11402
0.575733
1.714341
1.916899

17
2020-12-18 13:37:28.000
38.11402
0.5757737
1.625798
1.938099

18
2020-12-18 13:55:29.000
38.11402
0.5767096
1.537296
1.906605

19
2020-12-18 13:49:51.000
38.11402
0.5767096
1.565169
2.018748

20
2020-12-18 13:41:58.000
38.11402
0.5769944
1.571516
1.933827

21
2020-12-18 13:47:36.000
38.11402
0.5809414
1.569197
1.918324

22
2020-12-18 13:50:59.000
38.11402
0.5815111
1.530053
1.877958

23
2020-12-18 13:52:06.000
38.11402
0.5822029
1.5517
1.893746

24
2020-12-18 13:10:05.000
38.11402
0.6208184
0.5599451
0.5663742

25
2020-12-18 13:46:28.000
38.11402
0.6651306
1.747138
2.166944

26
2020-12-09 19:37:26.000
38.11402
0.7701126
1.79971
2.199008

27
2020-12-09 19:40:35.000
38.11402
0.8777803
1.963816
2.348628

28
2020-12-09 19:43:44.000
38.11402
0.9146054
2.03181
2.36763

29
2020-12-09 20:08:57.000
38.11402
0.9800767
1.925973
2.256586

30
2020-12-09 20:12:06.000
38.11402
0.989517
2.031566
2.393876

31
2020-12-09 20:21:33.000
38.11402
0.9961496
1.996572
2.349604

32
2020-12-09 20:15:15.000
38.11402
0.9977365
2.016429
2.367427

33
2020-12-09 20:02:39.000
38.11402
1.00384
2.054882
2.397619

34
2020-12-09 19:56:21.000
38.11402
1.007543
2.07071
2.410559

35
2020-12-09 20:27:52.000
38.11402
1.008886
1.991648
2.35758

36
2020-12-09 19:53:12.000
38.11402
1.012955
1.999095
2.355871

37
2020-12-09 20:18:25.000
38.11402
1.013118
2.014964
2.390295

38
2020-12-09 17:17:03.000
38.11402
1.017268
2.057364
2.391272

39
2020-12-09 20:05:48.000
38.11402
1.017878
2.030671
2.413937

40
2020-12-09 17:20:12.000
38.11402
1.020198
1.997589
2.335485

41
2020-12-09 17:26:30.000
38.11402
1.032853
2.013947
2.390539

42
2020-12-09 17:29:39.000
38.11402
1.051448
1.989817
2.351151

43
2020-12-09 19:59:30.000
38.11402
1.062109
2.022939
2.295282

44
2020-12-09 19:50:03.000
38.11402
1.076554
2.00414
2.414181

45
2020-12-09 17:32:49.000
38.11402
1.079769
2.144076
2.516233

46
2020-12-09 17:13:54.000
38.11402
1.080135
2.038971
2.409338

47
2020-12-09 20:24:42.000
38.11402
1.085832
2.015493
2.394324

48
2020-12-09 19:46:53.000
38.11402
1.095923
2.221632
2.55729

49
2020-12-09 19:26:16.000
38.11402
1.119117
2.237217
2.573688

50
2020-12-09 17:23:21.000
38.11402
1.152361
2.089509
2.455441

51
2020-12-09 18:26:21.000
38.11402
1.186094
2.210117
2.570189

52
2020-12-09 19:16:47.000
38.11402
1.197854
2.369421
2.803265

53
2020-12-09 17:42:15.000
38.11402
1.20176
2.144035
2.492958

54
2020-12-09 17:10:45.000
38.11402
1.204161
2.100048
2.44657

55
2020-12-09 18:42:06.000
38.11402
1.213113
2.282872
2.58675

56
2020-12-09 18:13:45.000
38.11402
1.222064
2.292719
2.679972

57
2020-12-09 19:23:06.000
38.11402
1.276142
2.382076
2.736004

58
2020-12-09 17:39:06.000
38.11402
1.278503
2.321528
2.57849

59
2020-12-09 19:19:56.000
38.11402
1.288228
2.393184
2.718181

60
2020-12-09 18:38:57.000
38.11402
1.305114
2.182325
2.510048

61
2020-12-09 19:13:38.000
38.11402
1.322042
2.209872
2.486814

62
2020-12-09 18:57:51.000
38.11402
1.324402
2.29634
2.558185

63
2020-12-09 18:20:04.000
38.11402
1.329976
2.257155
2.528033

64
2020-12-09 18:48:24.000
38.11402
1.330546
2.37821
2.621703

65
2020-12-09 18:54:42.000
38.11402
1.347107
2.307408
2.58614

66
2020-12-09 18:45:15.000
38.11402
1.356547
2.393184
2.751181

67
2020-12-09 17:35:57.000
38.11402
1.363383
2.30517
2.570596

68
2020-12-09 19:07:19.000
38.11402
1.368551
2.295933
2.532916

69
2020-12-09 19:29:25.000
38.11402
1.373149
2.493243
2.869103

70
2020-12-09 18:35:48.000
38.11402
1.40383
2.284744
2.563109

71
2020-12-09 19:10:29.000
38.11402
1.408794
2.26159
2.516477

72
2020-12-09 17:07:36.000
38.11402
1.40973
2.3411
2.702149

73
2020-12-09 18:16:54.000
38.11402
1.412701
2.346675
2.59851

74
2020-12-09 18:51:33.000
38.11402
1.412863
2.315058
2.639485

75
2020-12-09 16:48:42.000
38.11402
1.412985
2.613809
2.81238

76
2020-12-09 17:45:25.000
38.11402
1.41738
2.398474
2.725994

77
2020-12-09 17:58:01.000
38.11402
1.42031
2.5732
2.895389

78
2020-12-09 16:29:48.000
38.11402
1.420513
2.498451
2.763877

79
2020-12-09 18:32:40.000
38.11402
1.423484
2.30928
2.576577

80
2020-12-09 17:54:51.000
38.11402
1.423768
2.503131
2.790611

81
2020-12-09 18:10:36.000
38.11402
1.428611
2.338781
2.666951

82
2020-12-09 18:23:12.000
38.11402
1.441103
2.298416
2.584838

83
2020-12-09 19:04:09.000
38.11402
1.445212
2.332311
2.655151

84
2020-12-09 17:51:42.000
38.11402
1.455263
2.507078
2.827883

85
2020-12-09 19:01:00.000
38.11402
1.47512
2.307652
2.682373

86
2020-12-09 18:29:31.000
38.11402
1.48806
2.421424
2.636922

87
2020-12-09 16:39:16.000
38.11402
1.493838
2.393103
2.672852

88
2020-12-09 16:32:57.000
38.11402
1.500186
2.523395
2.819908

89
2020-12-09 16:58:09.000
38.11402
1.510602
2.633992
2.839643

90
2020-12-09 16:45:33.000
38.11402
1.538598
2.477495
2.727621

91
2020-12-09 16:36:06.000
38.11402
1.557275
2.274571
2.694336

92
2020-12-09 16:23:31.000
38.11402
1.588891
2.692383
2.962041

93
2020-12-09 17:48:33.000
38.11402
1.593693
2.585407
2.906986

94
2020-12-09 16:42:25.000
38.11402
1.596582
2.559528
2.839806

95
2020-12-09 16:55:01.000
38.11402
1.607528
2.602172
2.742433

96
2020-12-09 17:04:27.000
38.11402
1.648544
2.52075
2.809288

97
2020-12-09 16:51:52.000
38.11402
1.654037
2.671997
2.836835

98
2020-12-09 16:26:39.000
38.11402
1.664129
2.684204
2.866458

99
2020-12-09 17:01:19.000
38.11402
1.665797
2.636962
2.839928

100
2020-12-09 18:07:27.000
38.11402
1.707912
2.492714
2.968388


with d as (
Select top 100 row_number() over (order by CLD1) rn, *
  FROM EXTAUTOTABLE
 WHERE CLD1<>0 
   And CLD2<>0
   And CLD3<>0 
   And DieNumber=38.11402
), q as (
select 
  ((select cld1 from d where rn=25)+(select cld1 from d where rn=26)) / 2 Q1,
  ((select cld1 from d where rn=50)+(select cld1 from d where rn=51)) / 2 Q2,
  ((select cld1 from d where rn=75)+(select cld1 from d where rn=76)) / 2 Q3
),
qi as (
select q1,q2,q3, (q1 - ((q3-q1)*1.5)) b1, (q3-q1)*1.5 iq, (q3 + ((q3-q1)*1.5)) b2
 from q)
select 'ROW_NUMBER' METHOD, * from qi
/*select *
  from d
 where cld1<(select b1 from qi) or
       cld1>(select b2 from qi)*/


METHOD
q1
q2
q3
b1
iq
b2


ROW_NUMBER
0.7176216
1.1692275
1.4151825
-0.32871975
1.04634135
2.46152385


with d as (
Select top 100 row_number() over (order by CLD1) rn, *
  FROM EXTAUTOTABLE
 WHERE CLD1<>0 
   And CLD2<>0
   And CLD3<>0 
   And DieNumber=38.11402
   ), q as (
select top 1 
       PERCENTILE_CONT( .5) WITHIN GROUP(ORDER BY CLD1 ASC)
                  OVER(PARTITION BY[DieNumber]) As Q2,
       PERCENTILE_CONT(.25) WITHIN GROUP(ORDER BY CLD1 ASC) 
                  OVER(PARTITION BY[DieNumber]) As Q1,
       PERCENTILE_CONT(.75) WITHIN GROUP(ORDER BY CLD1 ASC)
                  OVER(PARTITION BY[DieNumber]) As Q3
 FROM d
),
qi as (
select q1,q2,q3, (q1 - ((q3-q1)*1.5)) b1, (q3-q1)*1.5 iq, (q3 + ((q3-q1)*1.5)) b2
 from q
)
select 'PERCENTILE_CONT' METHOD, * from qi
/*select *
  from d
 where cld1>=(select b1 from qi) and
       cld1<=(select b2 from qi)*/


METHOD
q1
q2
q3
b1
iq
b2


PERCENTILE_CONT
0.7438671
1.1692275
1.41408375
-0.261457875
1.005324975
2.419408725


with d as (
Select top 100 row_number() over (order by CLD1) rn, *
  FROM EXTAUTOTABLE
 WHERE CLD1<>0 
   And CLD2<>0
   And CLD3<>0 
   And DieNumber=38.11402
   ), q as (
select top 1 
       PERCENTILE_DISC( .51) WITHIN GROUP(ORDER BY CLD1 ASC)
                  OVER(PARTITION BY[DieNumber]) As Q2,
       PERCENTILE_DISC(.251) WITHIN GROUP(ORDER BY CLD1 ASC) 
                  OVER(PARTITION BY[DieNumber]) As Q1,
       PERCENTILE_DISC(.751) WITHIN GROUP(ORDER BY CLD1 ASC)
                  OVER(PARTITION BY[DieNumber]) As Q3
 FROM d
),
qi as (
select q1,q2,q3, (q1 - ((q3-q1)*1.5)) b1, (q3-q1)*1.5 iq, (q3 + ((q3-q1)*1.5)) b2
 from q
)
select 'PERCENTILE_DISC' METHOD, * from qi
/*select *
  from d
 where cld1>=(select b1 from qi) and
       cld1<=(select b2 from qi)*/


METHOD
q1
q2
q3
b1
iq
b2


PERCENTILE_DISC
0.7701126
1.186094
1.41738
-0.2007885
0.9709011
2.3882811

rn	Cur_Date	DieNumber	CLD1	CLD2	CLD3
1	2020-12-18 13:32:58.000	38.11402	0.07491158	0.7891152	1.048641
2	2020-12-18 13:44:13.000	38.11402	0.2987106	1.171445	1.569807
3	2020-12-09 15:53:09.000	38.11402	0.3217009	0.3264211	0.3272755
4	2020-12-09 16:20:21.000	38.11402	0.3254038	0.3179167	0.3227589
5	2020-12-18 13:43:06.000	38.11402	0.3271127	1.22357	1.431296
6	2020-12-18 13:34:06.000	38.11402	0.3331756	1.24534	1.595931
7	2020-12-09 15:44:49.000	38.11402	0.3448946	0.3328909	0.3433484
8	2020-12-18 13:45:21.000	38.11402	0.4075176	1.359518	1.738389
9	2020-12-18 13:35:13.000	38.11402	0.4551664	1.435202	1.762926
10	2020-12-18 13:39:43.000	38.11402	0.5050939	1.497012	1.867948
11	2020-12-18 13:48:43.000	38.11402	0.5332112	1.516136	1.857287
12	2020-12-18 13:40:51.000	38.11402	0.5509524	1.525821	1.879382
13	2020-12-18 13:38:36.000	38.11402	0.5691818	1.501935	1.816271
14	2020-12-18 13:53:14.000	38.11402	0.5718267	1.503604	1.844551
15	2020-12-18 13:54:21.000	38.11402	0.5731288	1.5423	1.910836
16	2020-12-18 13:36:21.000	38.11402	0.575733	1.714341	1.916899
17	2020-12-18 13:37:28.000	38.11402	0.5757737	1.625798	1.938099
18	2020-12-18 13:55:29.000	38.11402	0.5767096	1.537296	1.906605
19	2020-12-18 13:49:51.000	38.11402	0.5767096	1.565169	2.018748
20	2020-12-18 13:41:58.000	38.11402	0.5769944	1.571516	1.933827
21	2020-12-18 13:47:36.000	38.11402	0.5809414	1.569197	1.918324
22	2020-12-18 13:50:59.000	38.11402	0.5815111	1.530053	1.877958
23	2020-12-18 13:52:06.000	38.11402	0.5822029	1.5517	1.893746
24	2020-12-18 13:10:05.000	38.11402	0.6208184	0.5599451	0.5663742
25	2020-12-18 13:46:28.000	38.11402	0.6651306	1.747138	2.166944
26	2020-12-09 19:37:26.000	38.11402	0.7701126	1.79971	2.199008
27	2020-12-09 19:40:35.000	38.11402	0.8777803	1.963816	2.348628
28	2020-12-09 19:43:44.000	38.11402	0.9146054	2.03181	2.36763
29	2020-12-09 20:08:57.000	38.11402	0.9800767	1.925973	2.256586
30	2020-12-09 20:12:06.000	38.11402	0.989517	2.031566	2.393876
31	2020-12-09 20:21:33.000	38.11402	0.9961496	1.996572	2.349604
32	2020-12-09 20:15:15.000	38.11402	0.9977365	2.016429	2.367427
33	2020-12-09 20:02:39.000	38.11402	1.00384	2.054882	2.397619
34	2020-12-09 19:56:21.000	38.11402	1.007543	2.07071	2.410559
35	2020-12-09 20:27:52.000	38.11402	1.008886	1.991648	2.35758
36	2020-12-09 19:53:12.000	38.11402	1.012955	1.999095	2.355871
37	2020-12-09 20:18:25.000	38.11402	1.013118	2.014964	2.390295
38	2020-12-09 17:17:03.000	38.11402	1.017268	2.057364	2.391272
39	2020-12-09 20:05:48.000	38.11402	1.017878	2.030671	2.413937
40	2020-12-09 17:20:12.000	38.11402	1.020198	1.997589	2.335485
41	2020-12-09 17:26:30.000	38.11402	1.032853	2.013947	2.390539
42	2020-12-09 17:29:39.000	38.11402	1.051448	1.989817	2.351151
43	2020-12-09 19:59:30.000	38.11402	1.062109	2.022939	2.295282
44	2020-12-09 19:50:03.000	38.11402	1.076554	2.00414	2.414181
45	2020-12-09 17:32:49.000	38.11402	1.079769	2.144076	2.516233
46	2020-12-09 17:13:54.000	38.11402	1.080135	2.038971	2.409338
47	2020-12-09 20:24:42.000	38.11402	1.085832	2.015493	2.394324
48	2020-12-09 19:46:53.000	38.11402	1.095923	2.221632	2.55729
49	2020-12-09 19:26:16.000	38.11402	1.119117	2.237217	2.573688
50	2020-12-09 17:23:21.000	38.11402	1.152361	2.089509	2.455441
51	2020-12-09 18:26:21.000	38.11402	1.186094	2.210117	2.570189
52	2020-12-09 19:16:47.000	38.11402	1.197854	2.369421	2.803265
53	2020-12-09 17:42:15.000	38.11402	1.20176	2.144035	2.492958
54	2020-12-09 17:10:45.000	38.11402	1.204161	2.100048	2.44657
55	2020-12-09 18:42:06.000	38.11402	1.213113	2.282872	2.58675
56	2020-12-09 18:13:45.000	38.11402	1.222064	2.292719	2.679972
57	2020-12-09 19:23:06.000	38.11402	1.276142	2.382076	2.736004
58	2020-12-09 17:39:06.000	38.11402	1.278503	2.321528	2.57849
59	2020-12-09 19:19:56.000	38.11402	1.288228	2.393184	2.718181
60	2020-12-09 18:38:57.000	38.11402	1.305114	2.182325	2.510048
61	2020-12-09 19:13:38.000	38.11402	1.322042	2.209872	2.486814
62	2020-12-09 18:57:51.000	38.11402	1.324402	2.29634	2.558185
63	2020-12-09 18:20:04.000	38.11402	1.329976	2.257155	2.528033
64	2020-12-09 18:48:24.000	38.11402	1.330546	2.37821	2.621703
65	2020-12-09 18:54:42.000	38.11402	1.347107	2.307408	2.58614
66	2020-12-09 18:45:15.000	38.11402	1.356547	2.393184	2.751181
67	2020-12-09 17:35:57.000	38.11402	1.363383	2.30517	2.570596
68	2020-12-09 19:07:19.000	38.11402	1.368551	2.295933	2.532916
69	2020-12-09 19:29:25.000	38.11402	1.373149	2.493243	2.869103
70	2020-12-09 18:35:48.000	38.11402	1.40383	2.284744	2.563109
71	2020-12-09 19:10:29.000	38.11402	1.408794	2.26159	2.516477
72	2020-12-09 17:07:36.000	38.11402	1.40973	2.3411	2.702149
73	2020-12-09 18:16:54.000	38.11402	1.412701	2.346675	2.59851
74	2020-12-09 18:51:33.000	38.11402	1.412863	2.315058	2.639485
75	2020-12-09 16:48:42.000	38.11402	1.412985	2.613809	2.81238
76	2020-12-09 17:45:25.000	38.11402	1.41738	2.398474	2.725994
77	2020-12-09 17:58:01.000	38.11402	1.42031	2.5732	2.895389
78	2020-12-09 16:29:48.000	38.11402	1.420513	2.498451	2.763877
79	2020-12-09 18:32:40.000	38.11402	1.423484	2.30928	2.576577
80	2020-12-09 17:54:51.000	38.11402	1.423768	2.503131	2.790611
81	2020-12-09 18:10:36.000	38.11402	1.428611	2.338781	2.666951
82	2020-12-09 18:23:12.000	38.11402	1.441103	2.298416	2.584838
83	2020-12-09 19:04:09.000	38.11402	1.445212	2.332311	2.655151
84	2020-12-09 17:51:42.000	38.11402	1.455263	2.507078	2.827883
85	2020-12-09 19:01:00.000	38.11402	1.47512	2.307652	2.682373
86	2020-12-09 18:29:31.000	38.11402	1.48806	2.421424	2.636922
87	2020-12-09 16:39:16.000	38.11402	1.493838	2.393103	2.672852
88	2020-12-09 16:32:57.000	38.11402	1.500186	2.523395	2.819908
89	2020-12-09 16:58:09.000	38.11402	1.510602	2.633992	2.839643
90	2020-12-09 16:45:33.000	38.11402	1.538598	2.477495	2.727621
91	2020-12-09 16:36:06.000	38.11402	1.557275	2.274571	2.694336
92	2020-12-09 16:23:31.000	38.11402	1.588891	2.692383	2.962041
93	2020-12-09 17:48:33.000	38.11402	1.593693	2.585407	2.906986
94	2020-12-09 16:42:25.000	38.11402	1.596582	2.559528	2.839806
95	2020-12-09 16:55:01.000	38.11402	1.607528	2.602172	2.742433
96	2020-12-09 17:04:27.000	38.11402	1.648544	2.52075	2.809288
97	2020-12-09 16:51:52.000	38.11402	1.654037	2.671997	2.836835
98	2020-12-09 16:26:39.000	38.11402	1.664129	2.684204	2.866458
99	2020-12-09 17:01:19.000	38.11402	1.665797	2.636962	2.839928
100	2020-12-09 18:07:27.000	38.11402	1.707912	2.492714	2.968388