日常小知识

-- 是否包含0 
select cast(0 as string) in ('0','','null','NULL')       -- true

-- null值不参与逻辑计算
select min(salary) from demo where name = '小李'   -- 100
select max(salary) from demo where name = '小李'   -- 200

-- row_number() over()

-- 如果涉及排序null值对应的是最小的
select
    name,
    salary,
    row_number() over(partition by name order by time asc) as rank
from
(
    select  'wuchao' as name, 100 as salary,null as time       
    union all 
    select  'wuchao' as name, 200 as salary, 100 as time
)t_user

-- 如果涉及排序null值对应的是最小的
select
    name,
    salary,
    row_number() over(partition by name order by time desc) as rank
from
(
    select  'wuchao' as name, 100 as salary,null as time       
    union all 
    select  'wuchao' as name, 200 as salary, 100 as time
)t_user

https://data.bytedance.net/aeolus/#/queryEditor/query/9ec40b3a09f679b4?appId=36&blockId=2666570&group=default&taskId=17124409