#standardSQL CREATE TEMPORARY FUNCTION ARRAY_INT64_INCLUDE(arr ARRAY<INT64>, val INT64) RETURNS BOOL AS (( SELECT LOGICAL_OR(elem = val) FROM UNNEST(arr) as elem )); SELECT ARRAY_INT64_INCLUDE([1, 2, 3], 4)
![BigQuery Standard SQLである要素が配列中に含まれているかどうかを判定する方法 - Qiita](https://cdn-ak-scissors.b.st-hatena.com/image/square/f3b12589fd2eefd69739b3592f0a11ee147d3cf5/height=288;version=1;width=512/https%3A%2F%2Fqiita-user-contents.imgix.net%2Fhttps%253A%252F%252Fcdn.qiita.com%252Fassets%252Fpublic%252Farticle-ogp-background-412672c5f0600ab9a64263b751f1bc81.png%3Fixlib%3Drb-4.0.0%26w%3D1200%26mark64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTk3MiZoPTM3OCZ0eHQ9QmlnUXVlcnklMjBTdGFuZGFyZCUyMFNRTCVFMyU4MSVBNyVFMyU4MSU4MiVFMyU4MiU4QiVFOCVBNiU4MSVFNyVCNCVBMCVFMyU4MSU4QyVFOSU4NSU4RCVFNSU4OCU5NyVFNCVCOCVBRCVFMyU4MSVBQiVFNSU5MCVBQiVFMyU4MSVCRSVFMyU4MiU4QyVFMyU4MSVBNiVFMyU4MSU4NCVFMyU4MiU4QiVFMyU4MSU4QiVFMyU4MSVBOSVFMyU4MSU4NiVFMyU4MSU4QiVFMyU4MiU5MiVFNSU4OCVBNCVFNSVBRSU5QSVFMyU4MSU5OSVFMyU4MiU4QiVFNiU5NiVCOSVFNiVCMyU5NSZ0eHQtYWxpZ249bGVmdCUyQ3RvcCZ0eHQtY29sb3I9JTIzMjEyMTIxJnR4dC1mb250PUhpcmFnaW5vJTIwU2FucyUyMFc2JnR4dC1zaXplPTU2JnM9NWZiY2E0MDY0MGI2M2JmNzQ5N2VjYjk4NjYxZmFlNjU%26mark-x%3D142%26mark-y%3D57%26blend64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZoPTc2Jnc9NzcwJnR4dD0lNDBzaGlvemFraSZ0eHQtY29sb3I9JTIzMjEyMTIxJnR4dC1mb250PUhpcmFnaW5vJTIwU2FucyUyMFc2JnR4dC1zaXplPTM2JnR4dC1hbGlnbj1sZWZ0JTJDdG9wJnM9Yzk5ZDAxYWM4MTlmNTFmMTkyNWVhMWQyYzdmNjQ4ODI%26blend-x%3D142%26blend-y%3D436%26blend-mode%3Dnormal%26txt64%3DaW4g5qCq5byP5Lya56S-Wk9aTw%26txt-width%3D770%26txt-clip%3Dend%252Cellipsis%26txt-color%3D%2523212121%26txt-font%3DHiragino%2520Sans%2520W6%26txt-size%3D36%26txt-x%3D156%26txt-y%3D536%26s%3D75ce433ed15a32e0a2357fc498510248)
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
処理を実行中です
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く