此篇主要介绍去重和去重过程中空值的处理
源表部分内容
一、去重的四种方式
-- 去重时 空和null均参与计算
select name from demo.product_name group by name ;
select distinct name from demo.product_name ;
-- 伪列实现去重
select * from
(
select *,ROW_NUMBER() over(partition by name order by id ) as rn from demo.product_name
) a where rn =1
-- 使用union实现去重
select name from demo.product_name
union
select name from demo.product_name
-- 查找重复值
select name , count(1) as cnt from demo.product_name group by name having cnt > 1 ;
-- 窗口函数查重
select * from
(