回答編集履歴
1
修正
test
CHANGED
@@ -14,7 +14,7 @@
|
|
14
14
|
|
15
15
|
from (
|
16
16
|
|
17
|
-
select col
|
17
|
+
select coalesce(NO, ID) as 番号
|
18
18
|
|
19
19
|
, case WHEN date1 IS NULL THEN '9999-01-01' WHEN date1=0 THEN NULL ELSE date1 end as plnt
|
20
20
|
|