比如查到的网点名称为A,如何将A改为B呢
select distinct case when wdmc='A' THEN 'B' ELSE wdmc END AS 网点名称 from 表1
select 字段名 as 更改名 from 表
SELECT DISTINCT (CASE WHEN WDMC='A' THEN 'B' ELSE WDMC END) FROM .............