title: SQL Server : how to get max of columns
body: <p>In SQL Server, please tell me how to get max of columns. </p>
  
  <p>Data: </p>
  
  <pre><code> QRY_ID  |  SUBJECT1  |  SUBJECT2 | ..........................  SUBJECT20
  ------------------------------------------------------------------------------
     A     |    100     |    15     | ..........................     120   
     B     |    200     |    32     | ..........................     140  
     C     |    32      |    29     | ..........................     230  
     D     |    78      |    61     | ..........................     420  
     E     |    99      |    30     | ..........................     20  
  </code></pre>
  
  <p>Desired result: </p>
  
  <pre><code> QRY_ID  |  MAX(SUBJECT) | 
  --------------------------
     A     |    120    |  
     B     |    200    |  
     C     |    230    |     
     D     |    420    |      
     E     |    99     |   
  </code></pre>
  
  <p>Thanks ~! </p>