title: select query to identify numeric or alphanumeric values
body: <p>I have a table like below:</p>
  
  <pre><code>  TN  Tier
    90   1
    90   N3
    30   2
    40   3
    50   A
  </code></pre>
  
  <p>"Tier" column may contain numeric as well as alpha-numeric values for any TN. I want to run a select query on above table so that if for any TN, there are both(numeric and alpha-numeric) values present in Tier column then it should be called as "Mix" otherwise "Numeric" or "Non-Numeric".</p>
  
  <p>Desired Output :</p>
  
  <pre><code> TN   Result
   90    Mix
   30   Numeric
   40   Numeric
   50   Non-Numeric
  </code></pre>
  
  <p>I am able to achieve it by using multiple temp tables but i want to avoid using temp tables. Any help would be appreciated!!!</p>