窗口函数使用时报错 ’ Unknown column ‘xx’ in ‘where clause’ ’ 的解决
# 查询各科成绩前三名的记录
select*,dense_rank()over(partition by cid order by score desc) as r
from sc
where r<=3
此时调用窗口函数却报错:
解决办法:嵌套一层作为子查询,问题解决
# 查询各科成绩前三名的记录
select * from
(select*,dense_rank() over (partition by cid order by score desc) as r from sc) a
where r<=3