网站首页 站内搜索

搜索结果

查询Tags标签: time01,共有 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 人评论 次浏览
扫一扫关注最新编程教程