Sql中的窗口函数
案例
原始数据
## 入门程序
写法一:
select
province,city,gdp,people, rank() over (partition by province order by gdp) as ranking
from windowfunc;
写法二:
select
province,city,gdp,people,rank() over w1 as ranking
from windowfunc
window w1 as (partition by province ord
原创
2020-10-14 19:29:24 ·
1284 阅读 ·
0 评论