SQL Server分页查询错误——ORDER BY子句在视图、内联函数、派生表、子查询和公共表表达式中无效

这是一个查询，我正在做返回页面数据到我的web应用程序，以获得前100个元素:

SELECT * FROM (SELECT ROWNUM AS RN, Id,DateTime FROM Schema.MyDb WHERE 
Deleted='F' AND (Code>=2) AND (Type LIKE '%stock%') 
ORDER BY Datetime DESC) WHERE ROWNUM < 
100 AND RN > 0

这在Oracle数据库上工作得很好，但在SQL Server 2012下运行时，我得到以下错误:

Message 1033, Level 15, State 1, Server NBOOK'SQLEXPRESS, Line 1:
The ORDER BY clause is invalid in views, inline functions, derived tables, subqu
eries, and common table expressions, unless TOP, OFFSET or FOR XML is also speci
fied.

关于如何解决这个问题并使其在不丢失逻辑的情况下工作(最终结果需要是有序查询的前100行)的任何提示?

SELECT *
FROM (SELECT row_number() over (order by DateTime desc) as RN, Id, DateTime
      FROM Schema.MyDb
      WHERE Deleted = 'F' AND (Code >= 2) AND (Type LIKE '%stock%') 
     ) t
WHERE RN < 100 AND RN > 0;