回答編集履歴
1
修正
test
CHANGED
|
@@ -6,7 +6,7 @@
|
|
|
6
6
|
|
|
7
7
|
|
|
8
8
|
|
|
9
|
-
karute_no内のpkeyが最大のもので、
|
|
9
|
+
valid_flg='1'のデータのうち、karute_no内のpkeyが最大のもので、指定の日付のデータ
|
|
10
10
|
|
|
11
11
|
```SQL
|
|
12
12
|
|
|
@@ -14,11 +14,9 @@
|
|
|
14
14
|
|
|
15
15
|
FROM tbl_test AS t1
|
|
16
16
|
|
|
17
|
-
WHERE
|
|
17
|
+
WHERE kensa_date = '2018-11-06'
|
|
18
18
|
|
|
19
|
-
and tbl_test_A.kensa_date = '2018-11-06'
|
|
20
|
-
|
|
21
|
-
and pkey=(select max(pkey) from tbl_test where karute_no=t1.karute_no)
|
|
19
|
+
and pkey=(select max(pkey) from tbl_test where valid_flg='1' and karute_no=t1.karute_no)
|
|
22
20
|
|
|
23
21
|
ORDER BY pkey asc
|
|
24
22
|
|