回答編集履歴
1
変更
test
CHANGED
|
@@ -117,3 +117,31 @@
|
|
|
117
117
|
|
|
118
118
|
|
|
119
119
|
```
|
|
120
|
+
|
|
121
|
+
|
|
122
|
+
|
|
123
|
+
（２）につきましてもPostgres都合上、下記に修正いたしました。
|
|
124
|
+
|
|
125
|
+
```(2)
|
|
126
|
+
|
|
127
|
+
SELECT product.*
|
|
128
|
+
|
|
129
|
+
FROM product
|
|
130
|
+
|
|
131
|
+
INNER JOIN(
|
|
132
|
+
|
|
133
|
+
SELECT type, MAX(price) AS max_price
|
|
134
|
+
|
|
135
|
+
FROM product
|
|
136
|
+
|
|
137
|
+
GROUP BY type
|
|
138
|
+
|
|
139
|
+
) tmp
|
|
140
|
+
|
|
141
|
+
ON product.type = tmp.type
|
|
142
|
+
|
|
143
|
+
AND product.price = tmp.max_price;
|
|
144
|
+
|
|
145
|
+
```
|
|
146
|
+
|
|
147
|
+
|