回答編集履歴

1

変更

2018/10/11 02:32

投稿

sazi
sazi

スコア25243

test CHANGED
@@ -2,11 +2,11 @@
2
2
 
3
3
  ```SQL
4
4
 
5
- SELECT ary_f[OFFSET(0)] f0,
5
+ SELECT case when ARRAY_LENGTH(ary_f)>=1 then ary_f[OFFSET(0)] end f0,
6
6
 
7
- ary_f[OFFSET(1)] f1,
7
+ case when ARRAY_LENGTH(ary_f)>=2 then ary_f[OFFSET(1)] end f1,
8
8
 
9
- ary_f[OFFSET(2)] f2
9
+ case when ARRAY_LENGTH(ary_f)>=3 then ary_f[OFFSET(2)] end f2
10
10
 
11
11
  from tbl
12
12