Excel--------实用功能(数据对比)

--excel数据在sql中查询展示出来

SELECT * FROM (SELECT '101001' as code ,'上海宝山站' as name union all
SELECT '102083' as code ,'鲜驿站紫桂花园店' as name union all
SELECT '102170' as code ,'杭州上城凤山店站送货' as name union all
SELECT 'C046' as code ,'上海太阳山前置仓' as name union all
SELECT 'C047' as code ,'上海大渡河前置仓' as name
) t

 

--VLOOKUP

 

 

 

 

--数据对比方法

 

转载于:https://www.cnblogs.com/chocolatexll/p/10763941.html