回答編集履歴
3
訂正内容を追記
answer
CHANGED
|
@@ -14,9 +14,11 @@
|
|
|
14
14
|
('kengo', 16, 0909)
|
|
15
15
|
;
|
|
16
16
|
|
|
17
|
+
# select ,max( name ) as name, max( age ) as age → マチガイ
|
|
17
18
|
select name, max( age ) as age
|
|
18
19
|
from users
|
|
19
20
|
group by name
|
|
20
21
|
order by age asc
|
|
21
22
|
|
|
22
|
-
```
|
|
23
|
+
```
|
|
24
|
+
すみません`name`に`max`使っていたところを「マチガイ」として削除致しました。
|
2
訂正
answer
CHANGED
|
@@ -14,7 +14,7 @@
|
|
|
14
14
|
('kengo', 16, 0909)
|
|
15
15
|
;
|
|
16
16
|
|
|
17
|
-
select
|
|
17
|
+
select name, max( age ) as age
|
|
18
18
|
from users
|
|
19
19
|
group by name
|
|
20
20
|
order by age asc
|
1
SQLfiddleを追加
answer
CHANGED
|
@@ -1,5 +1,19 @@
|
|
|
1
1
|
こちらでいけると思います。大きいは`max`です。
|
|
2
|
+
|
|
3
|
+
[下記のコードを実行する](http://sqlfiddle.com/#!9/110fab/4)
|
|
2
4
|
```SQL
|
|
5
|
+
CREATE TABLE users
|
|
6
|
+
(`name` varchar(6), `age` int, `birth day` text)
|
|
7
|
+
;
|
|
8
|
+
INSERT INTO users
|
|
9
|
+
(`name`, `age`, `birth day`)
|
|
10
|
+
VALUES
|
|
11
|
+
('taro', 13, 0701),
|
|
12
|
+
('ichiro', 14, 0808),
|
|
13
|
+
('taro', 14, 0701),
|
|
14
|
+
('kengo', 16, 0909)
|
|
15
|
+
;
|
|
16
|
+
|
|
3
17
|
select max( name ) as name, max( age ) as age
|
|
4
18
|
from users
|
|
5
19
|
group by name
|