WITH Notice_CTE AS (SELECT *, ROW_NUMBER() OVER (ORDER BY [DateTime] DESC) AS RowNumber
FROM NoticeInfor)
SELECT *
FROM Notice_CTE
WHERE RowNumber BETWEEN 1 AND 5
结果提示“不支持 OVER SQL 构造或语句”。这是怎么回事啊?望各位高手不吝赐教! ------解决方案-------------------- select @@VERSION看看版本
2000不支持 ------解决方案-------------------- SELECT *, ROW_NUMBER() OVER (ORDER BY [DateTime] DESC) AS RowNumber
FROM NoticeInfor