回答編集履歴
1
修正
answer
CHANGED
|
@@ -20,8 +20,10 @@
|
|
|
20
20
|
```
|
|
21
21
|
後は上記に並びを指定するだけです。
|
|
22
22
|
```SQL
|
|
23
|
+
select * from (
|
|
23
24
|
select 1 as item_ID, item1 as value from post
|
|
24
25
|
union all select 2 as item_ID, item2 as value from post
|
|
25
26
|
union all select 3 as item_ID, item3 as value from post
|
|
27
|
+
) tmp
|
|
26
28
|
order by value
|
|
27
29
|
```
|