回答編集履歴
1
結果を追記
test
CHANGED
|
@@ -2,15 +2,21 @@
|
|
|
2
2
|
|
|
3
3
|
```sql
|
|
4
4
|
CREATE TABLE test_table (id VARCHAR(3), ver INT);
|
|
5
|
-
INSERT INTO test_table
|
|
5
|
+
INSERT INTO test_table VALUES ('001', 1);
|
|
6
|
-
INSERT INTO test_table
|
|
6
|
+
INSERT INTO test_table VALUES ('001', 2);
|
|
7
|
-
INSERT INTO test_table
|
|
7
|
+
INSERT INTO test_table VALUES ('001', 3);
|
|
8
|
-
INSERT INTO test_table
|
|
8
|
+
INSERT INTO test_table VALUES ('002', 1);
|
|
9
|
-
INSERT INTO test_table
|
|
9
|
+
INSERT INTO test_table VALUES ('002', 2);
|
|
10
|
-
INSERT INTO test_table
|
|
10
|
+
INSERT INTO test_table VALUES ('003', 1);
|
|
11
11
|
|
|
12
12
|
SELECT id, ver FROM test_table
|
|
13
13
|
WHERE (id, ver) IN (
|
|
14
14
|
SELECT id, MAX(ver) FROM test_table GROUP BY id
|
|
15
15
|
);
|
|
16
|
+
|
|
17
|
+
-- 結果
|
|
18
|
+
id ver
|
|
19
|
+
001 3
|
|
20
|
+
002 2
|
|
21
|
+
003 1
|
|
16
22
|
```
|