title: Exclude specific column from result in SQL Server
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/729197/sql-exclude-a-column-using-select-except-columna-from-tablea">SQL exclude a column using SELECT * [except columnA] FROM tableA?</a>  </p>
  </blockquote>
  
  
  
  <p>I have following query and I want to exclude the column <code>RowNum</code> from the result, how can I do it ?</p>
  
  <pre><code>SELECT  *
  FROM    
     (SELECT    
         ROW_NUMBER() OVER ( ORDER BY [Report].[dbo].[Reflow].ReflowID ) AS RowNum, *
      FROM      
         [Report].[dbo].[Reflow]
      WHERE     
         [Report].[dbo].[Reflow].ReflowProcessID = 2) AS RowConstrainedResult
  WHERE   
     RowNum &gt;= 100 AND RowNum &lt; 120
  ORDER BY 
     RowNum
  </code></pre>
  
  <p>Thanks.</p>