回答編集履歴
3
推敲
answer
CHANGED
|
@@ -14,7 +14,7 @@
|
|
|
14
14
|
with rand as (
|
|
15
15
|
select trunc(random() * 3) as random_value
|
|
16
16
|
)
|
|
17
|
-
select
|
|
17
|
+
select count(*)
|
|
18
18
|
from (values (0),(1),(2)) as rand_test(testid)
|
|
19
19
|
inner join rand
|
|
20
20
|
on rand_test.testid=rand.random_value
|
2
推敲
answer
CHANGED
|
@@ -16,6 +16,6 @@
|
|
|
16
16
|
)
|
|
17
17
|
select testid , random_value
|
|
18
18
|
from (values (0),(1),(2)) as rand_test(testid)
|
|
19
|
-
inner join rand
|
|
19
|
+
inner join rand
|
|
20
|
-
|
|
20
|
+
on rand_test.testid=rand.random_value
|
|
21
21
|
```
|
1
追記
answer
CHANGED
|
@@ -5,4 +5,17 @@
|
|
|
5
5
|
select count(*)
|
|
6
6
|
from rand_test
|
|
7
7
|
where testid =(select trunc(random() * 3))
|
|
8
|
+
```
|
|
9
|
+
追記
|
|
10
|
+
--
|
|
11
|
+
試してみたら、サブクエリーでは駄目でしたね。
|
|
12
|
+
With式なら大丈夫でした。
|
|
13
|
+
```SQL
|
|
14
|
+
with rand as (
|
|
15
|
+
select trunc(random() * 3) as random_value
|
|
16
|
+
)
|
|
17
|
+
select testid , random_value
|
|
18
|
+
from (values (0),(1),(2)) as rand_test(testid)
|
|
19
|
+
inner join rand
|
|
20
|
+
on rand_test.testid=rand.random_value
|
|
8
21
|
```
|