title: What happens if I SELECT something AS a name then something else AS the same name?
body: <p>I've already answered my question but didn't see it on here, so here we go.  Please feel free to link to the question if it has been asked exactly.
  I simplified my question to the following code:</p>
  
  <pre><code>SELECT 'a' AS col1, 'b' AS col1
  </code></pre>
  
  <p>Will this give a same column name error?</p>
  
  <p>Will the last value always be returned or is there a chance col1 could be 'a'?</p>