回答編集履歴
1
修正
answer
CHANGED
|
@@ -6,7 +6,7 @@
|
|
|
6
6
|
from (
|
|
7
7
|
select (select min(item) from (values (plnt),(plnk),(koushin)) as list(item)) as least, 番号
|
|
8
8
|
from (
|
|
9
|
-
select
|
|
9
|
+
select coalesce(NO, ID) as 番号
|
|
10
10
|
, case WHEN date1 IS NULL THEN '9999-01-01' WHEN date1=0 THEN NULL ELSE date1 end as plnt
|
|
11
11
|
, case WHEN date2 IS NULL THEN '9999-01-01' WHEN date2=0 THEN NULL ELSE date2 end as plnk
|
|
12
12
|
, case WHEN 更新日時 IS NULL THEN '9999-01-01' WHEN 更新日時=0 THEN NULL ELSE 更新日時 end as koushin
|