回答編集履歴
1
修正
test
CHANGED
|
@@ -1,3 +1,5 @@
|
|
|
1
|
+
※SQLiteで動作確認を行った。
|
|
2
|
+
|
|
1
3
|
1. idが同じカラムが2つ
|
|
2
4
|
|
|
3
5
|
2. hizukeが0と0以外
|
|
@@ -6,9 +8,9 @@
|
|
|
6
8
|
|
|
7
9
|
SELECT
|
|
8
10
|
|
|
9
|
-
T1.ID AS ID
|
|
11
|
+
T1.ID AS ID
|
|
10
12
|
|
|
11
|
-
, T1.HIZUKE AS HIZUKE
|
|
13
|
+
, T1.HIZUKE AS HIZUKE
|
|
12
14
|
|
|
13
15
|
FROM
|
|
14
16
|
|