title: Windowed functions and NEXT VALUE FOR functions do not support constants as ORDER BY clause expressions
body: <p>When running this statement I get the error <code>Windowed functions and NEXT VALUE FOR functions do not support constants as ORDER BY clause expressions.</code></p>
  
  <pre><code>SELECT * FROM (select ROW_NUMBER() OVER (ORDER BY 'publishdate DESC') as RowNum,
  * FROM news WHERE publishdate &lt;=getdate()) as info
  WHERE RowNum &gt; 0 AND RowNum &lt;= (100)
  </code></pre>
  
  <p>I want to use this statement to retrieve a resultset in a paged gridview.</p>
  
  <p>How to get this statement to run? </p>