title: BigQuery Standard SQL: how to return the first value of array?
body: <p>Small working example</p>
  
  <pre><code>SELECT SPLIT("hello::hej::hallo::hoi", "::")
  </code></pre>
  
  <p>returns an array <code>[hello, hej, hallo, hoi]</code> where I want to select the first element i.e. <code>hello</code>. BG Standard provides no <code>FIRST</code>, instead <code>FIRST_VALUE(..) OVER()</code> which I cannot get working for this example above, so</p>
  
  <p><strong>How can I select the first value of array with BigQuery Standard SQL?</strong></p>