- 博客(1)
- 收藏
- 关注
原创 2表字段相同合并成一张表列合并
select case when t1.a is null then t2.a else t1.a end as a,t1.b,t2.cfrom(select *,ROW_NUMBER() over(partition by a order by a) as rowid from a1) t1full join(select *,ROW_NUMBER() over(partition by a o...
2018-03-23 17:05:17 4096 1
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人