title: What is the difference between 'end' and 'end as'
body: <p>Simple question. I noticed it seems I can use them interchangeably, but I wasn't sure if they were the exact same command. I searched online and couldn't find anything? Here an example query that gives me the same result:</p>
  
  <pre><code>select 
  case when ID in ('1', '2', '3')
  then 'Jack'
  else 'Jim'
  end as Person
  from Table.Names
  
  select
  case when ID in ('1', '2', '3')
  then 'Jack'
  else 'Jim'
  end Person
  from Table.Names
  </code></pre>