- 博客(3)
- 收藏
- 关注
原创 退换货订单union合并,union巧用
aa.GMT_CREATE as 订单时间,aa.GMT_MODIFIED as 支付时间 /*由于线上的refund_date为空所以改为modifytime*/aa.CONTRACT_BILLCODE as 订单号,aa.REFUND_CODE as 退款单号,aa.CONTRACT_BILLCODE as 订单号,aa.REFUND_CODE as 退款单号,aa.GMT_CREATE as 订单时间,aa.refund_date as 支付时间。a.DATA_BMONEY as 订单金额,
2023-03-16 12:13:05
79
原创 maxcompute中结合quickBi统计uv按日期每天中的每小时uv环比图
select --substr(to_date('data_time','yyyy-mm-dd'),1,10) , substr(data_time,1,10) as date, substr(concat(substr(data_time,1,13),':00:00'),11,10) as time, count(distinct utdid) as uv from max_bbj.dwd_insurance_news_pv_uv_daily where datediff(now(),to_
2022-04-10 17:34:30
339
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人