title: Split and get second row as value
body: <p>I'm using below query to split the names as shown below:</p>
  
  <pre><code>select value from STRING_SPLIT('Name1~Name2~Name3' , '~' );
  </code></pre>
  
  <p>How to get second name i.e, <code>Name2</code>, <strong>without using <code>WHERE</code> condition</strong>?</p>
  
  <p><strong>Note: Names can be dynamic</strong></p>
  
  <p><a href="https://i.stack.imgur.com/3xBSh.png" rel="noreferrer"><img src="https://i.stack.imgur.com/3xBSh.png" alt="enter image description here"></a></p>