回答編集履歴
2
戻し
test
CHANGED
|
@@ -8,5 +8,5 @@
|
|
|
8
8
|
, lead(date, 1, 99991231) over(partition by CaseNo order by date) as LeadDate
|
|
9
9
|
from Table1
|
|
10
10
|
) tr
|
|
11
|
-
ON dt.date
|
|
11
|
+
ON dt.date >= tr.date and dt.date < tr.LeadDate
|
|
12
12
|
```
|
1
訂正
test
CHANGED
|
@@ -8,5 +8,5 @@
|
|
|
8
8
|
, lead(date, 1, 99991231) over(partition by CaseNo order by date) as LeadDate
|
|
9
9
|
from Table1
|
|
10
10
|
) tr
|
|
11
|
-
ON dt.date
|
|
11
|
+
ON dt.date <= tr.date and dt.date > tr.LeadDate
|
|
12
12
|
```
|