1、重复计数
SELECT id, name, email,
count(*) over (partition by email) cnt
FROM people
2、字段相同值计数排序
SELECT id, name, email,
row_number() over (PARTITION BY email ORDER BY id DESC) AS row_num
FROM people
3、去重查询
3.1、select distinct on (a) a,b,c from t_distinct;返回a唯一的任意行
3.2、select distinct a,b,c from t_distinct;返回 a,b,c 唯一值。