- 博客(2)
- 收藏
- 关注
RSS订阅原创 with as 与 union 并用 拼接12表
with tb1 as (select * from analytic_layer_zbyy_sjbyy_002_ysrhdsj00.a2cw1005 as A where K0YEAR = 2018 and G0tab_name like '员工情况%' and g0company_code IN (select ZGXTQYBM ...
2021-12-30 15:37:33
556
原创 四表关联
select A.g0company_code AS g0company_code, A.K0YEAR AS K0YEAR, A.G0field_val as 硕士及以上, B.G0field_val as 本科, C.G0field_val as 专科, D.G0field_val as 中专及以下 from ( SELECT tb3_2.g0company_code,tb3_2.K0YEAR,tb3_1.G0field_val FROM ( select * ...
2021-12-30 15:18:57
272
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人