回答編集履歴
1
修正
answer
CHANGED
|
@@ -7,5 +7,5 @@
|
|
|
7
7
|
,case datediff([起点日],日付) when 1 then 出勤 end as day2
|
|
8
8
|
,case datediff([起点日],日付) when 2 then 出勤 end as day3
|
|
9
9
|
from テーブル
|
|
10
|
-
where 日付 between [起点日] and
|
|
10
|
+
where 日付 between [起点日] and date_add([起点日], interval 3 days)
|
|
11
11
|
```
|