热门标签
更多>
搜索结果
查询Tags标签: time02,共有 2条记录-
sql-常见面试题汇总
1.连续7天登陆但未下单的用户select c.user_id, count(c.cum) as cum_01 from (select a.user_id,a.time01 - row_number() over(partition by a.user_id order_by a.time01 asc) as cum from (select distinct user_id ,to_char(event_time,yyyymmdd) as time01from u…
2021/8/1 19:36:18 人评论 次浏览 -
sql-常见面试题汇总
1.连续7天登陆但未下单的用户select c.user_id, count(c.cum) as cum_01 from (select a.user_id,a.time01 - row_number() over(partition by a.user_id order_by a.time01 asc) as cum from (select distinct user_id ,to_char(event_time,yyyymmdd) as time01from u…
2021/8/1 19:36:18 人评论 次浏览