SQL : Why doesn't this ROWNUMBER function work?

Question

SELECT  DateErrored
FROM     (SELECT Category, ROW_NUMBER  (Partition by dateerrored ORDER BY category DESC)AS Row FROM AspErrors)
            AS LogWithRowNumbers
WHERE  Row >= 1 AND Row <= 10

Answer 1

Change ROW_NUMBER to ROW_NUMBER() OVER.

Link to documentation.