postgresql 对字段中的重复值计数

1、重复计数
SELECT 号码,属性,count(*) over (PARTITION BY 号码) AS “row_num”
from (select 号码,‘需更换终端用户’ as 属性 from “市场部0330需更换终端用户明细” union
SELECT 号码,‘需更换卡槽’ as 属性 FROM “市场部0330需升级终端版本打开VoLTE开关更换卡槽”) as ss

2、字段相同值计数排序
SELECT 号码,属性,row_number() over (PARTITION BY 号码 ORDER BY 号码 DESC) AS “row_num”
from (select 号码,‘需更换终端用户’ as 属性 from “市场部0330需更换终端用户明细” union
SELECT 号码,‘需更换卡槽’ as 属性 FROM “市场部0330需升级终端版本打开VoLTE开关更换卡槽”) as ss