Windowed functions and NEXT VALUE FOR functions do not support constants as ORDER BY clause expressions

Question

When running this statement I get the error Windowed functions and NEXT VALUE FOR functions do not support constants as ORDER BY clause expressions.

SELECT * FROM (select ROW_NUMBER() OVER (ORDER BY 'publishdate DESC') as RowNum,
* FROM news WHERE publishdate <=getdate()) as info
WHERE RowNum > 0 AND RowNum <= (100)

I want to use this statement to retrieve a resultset in a paged gridview.

How to get this statement to run?

Answer 1

SELECT * FROM (select ROW_NUMBER() OVER (ORDER BY publishdate DESC) as RowNum,
* FROM news WHERE publishdate <=getdate()) as info
WHERE RowNum > 0 AND RowNum <= (100)

You dont need the ' in (ORDER BY publishdate DESC)