回答編集履歴
1
追記
test
CHANGED
|
@@ -45,3 +45,27 @@
|
|
|
45
45
|
select id,max(value) as max_val from tbl group by id;
|
|
46
46
|
|
|
47
47
|
```
|
|
48
|
+
|
|
49
|
+
|
|
50
|
+
|
|
51
|
+
# 元のテーブルを利用
|
|
52
|
+
|
|
53
|
+
普通にいけますよね？
|
|
54
|
+
|
|
55
|
+
```SQL
|
|
56
|
+
|
|
57
|
+
create table tbl2 (id int,data1 int,data2 int,data3 int,data4 int,data5 int);
|
|
58
|
+
|
|
59
|
+
insert into tbl2 values
|
|
60
|
+
|
|
61
|
+
(1,700,200,300,400,100)
|
|
62
|
+
|
|
63
|
+
,(2,100,800,200,300,200)
|
|
64
|
+
|
|
65
|
+
,(3,100,300,900,100,100);
|
|
66
|
+
|
|
67
|
+
select id,greatest(data1,data2,data3,data4,data5) as max_val from tbl2;
|
|
68
|
+
|
|
69
|
+
```
|
|
70
|
+
|
|
71
|
+
|