2020年6月4日
在拉链表中取用户每个月最后一天的状态
摘要： with data as ( select t1.* ,row_number() over(partition by id order by end_date desc) as rn from ( select 1 as id,20 as status,'2020-03-28' as start_d 阅读全文
posted @ 2020-06-04 16:54 chenzechao 阅读(1305) 评论(0) 推荐(0)