先占个坑,sql的with函数
- 建表重命名,注意事项:1.格式:with+表名+as+(表内容) 2. 建多个表时中间用逗号隔开 3.表要用括号括起来 4.前面的表可以被后面使用
- 后续使用直接表名即可
例如后面这段,可作为参考
with order_info as (
select
distinct user_id,
sub_order_id,
order_id,
goods_id
from
order_di
where
dt = '2021-03-30'
),
goods_cat_info as (
select
a.*,
b.cat_name
from
order_info a
left join (
select
goods_id,
max(cat_name) as cat_name
from
gos_category_df
where
dt = '2021-03-30'
group by
goods_id
) b on a.goods_id = b.goods_id
)
select
*
from
goods_cat_info;