朝圣者(梁鹏)

select 板卡型号 from (select *,ROW_NUMBER() over(PARTITION by [网元网管名称],[机框全名],[槽号],[ET号] order by [板卡型号]) as rownumber FROM [ET信息]) as tt where rownumber=2 group by 板卡型号

select a,c INTO Table2 from Table1
select a,c INTO Table2 from Table1

UPDATE table1 SET filed1=table2.field2 FROM table2 WHERE table1.bb=table2.bb

anyShare分享到：