数据表“TB_GY”,有两个字段“shortName”,"typeName"
执行前
完成效果
我们要达到的效果不是,合并所有重复,而是合并上下行相同的重复值。
1. 我们先用 ROW_NUMBER() OVER 要把TB_GY表做上下行比较,去重复。
select A.shortName ,A.typeName from (Select shortName,typeName, ROW_NUMBER() over(order by typeName ) as rows from TB_GY) A left join (Select shortName,typeName, ROW_NUMBER() over(order by typeName ) as rows from TB_G