不对,搞错了 ,刚才在2000中运行的出现上述错误,在2005中运行有如下错误消息 4108,级别 15,状态 1,第 1 行 开窗函数只能出现在 SELECT 或 ORDER BY 子句中。
update a set sum9rankclass = b.pid from stuexamscore as a left join (select *,pid = rank() over (partition by stuGrade,examType,examDate order by sum9 DESC) from stuExamScore ) b on a.id = b.id
'rank' 不是可以识别的 函数名。好像格式有点问题
开窗函数只能出现在 SELECT 或 ORDER BY 子句中。
set sum9rankclass = b.pid
from stuexamscore as a
left join (select *,pid = rank() over (partition by stuGrade,examType,examDate order by sum9 DESC) from stuExamScore ) b
on a.id = b.id