--例子:用月份排序对号码进行分组划分等级
select imonth,vcmsisdn,phonebrand,phonetype,
RANK() OVER ( PARTITION BY vcmsisdn ORDER BY imonth desc) rn
from TableA
SQL的RANK()OVER 划分等级的用法
最新推荐文章于 2024-06-17 10:06:14 发布
--例子:用月份排序对号码进行分组划分等级
select imonth,vcmsisdn,phonebrand,phonetype,
RANK() OVER ( PARTITION BY vcmsisdn ORDER BY imonth desc) rn
from TableA